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) |