| Name | Data type | Not Null? | Primary key? | Default | Comment |
|---|---|---|---|---|---|
| id | integer | Yes | Yes | nextval('territories_id_seq'::regclass) | |
| code | character varying(10) | No | No | Territory code | |
| name | character varying(80) | No | No | Territory name | |
| description | text | No | No | Territory description | |
| _dbversion | integer | No | No | ||
| _created | timestamp without time zone | No | No | ||
| _created_by | character varying(3) | No | No | ||
| _modified | timestamp without time zone | No | No | ||
| _modified_by | character varying(3) | No | No | ||
| udf_data | hstore | No | No | ''::hstore | hstore field containing user defined data |
| Name | Type | Definition | Comment |
|---|---|---|---|
| territory_pkey | Primary key | (id) |