public.activitycodedetails
Description
Activity Code Lookup Data
Columns
| keyid |
varchar(100) |
|
false |
|
|
|
| id |
varchar(50) |
|
true |
|
|
|
| businessunitid |
varchar(50) |
|
true |
|
|
|
| name |
varchar(50) |
|
true |
|
|
|
| active |
bit(1) |
|
true |
|
|
|
| defaultcode |
bit(1) |
|
true |
|
|
|
| category |
varchar(50) |
|
true |
|
|
|
| lengthinminutes |
integer |
|
true |
|
|
|
| countsaspaidwork |
bit(1) |
|
true |
|
|
|
| countsasworktime |
bit(1) |
|
true |
|
|
|
| updated |
timestamp without time zone |
|
true |
|
|
|
Constraints
| activitycodedetails_pkey |
PRIMARY KEY |
PRIMARY KEY (keyid) |
Indexes
| activitycodedetails_pkey |
CREATE UNIQUE INDEX activitycodedetails_pkey ON
public.activitycodedetails USING btree (keyid) |