| Name | Data type | Not Null? | Primary key? | Default | Comment |
|---|---|---|---|---|---|
| id | integer | Yes | Yes | nextval('sales_departments_id_seq'::regclass) | Unique identifier |
| revenue | character varying(24) | No | No | General Ledger account for revenue | |
| cost_of_goods | character varying(24) | No | No | General LEdger account for cost of goods | |
| inventory | character varying(24) | No | No | General LEdger account for inventory asset | |
| code | character varying(10) | No | No | Sales department code | |
| description | character varying(30) | No | No | Sales department description |
| Name | Type | Definition | Comment |
|---|---|---|---|
| sales_dept_pkey | Primary key | (id) |