| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| keyid | varchar(100) | false | ||||
| userid | varchar(50) | true | ||||
| skillid | varchar(50) | true | ||||
| proficiency | numeric(20,2) | true | ||||
| state | varchar(50) | true | ||||
| updated | timestamp without time zone | true |
| Name | Type | Definition |
|---|---|---|
| userskillmappings_pkey | PRIMARY KEY | PRIMARY KEY (keyid) |
| Name | Definition |
|---|---|
| userskillmappings_pkey | CREATE UNIQUE INDEX userskillmappings_pkey ON public.userskillmappings USING btree (keyid) |