#	Column Name	Nullable	Data Type	Max Length	Description
1	office_id		integer	0	The primary key of this table, which is also a serial field.
2	office_code		character varying	12	The code given to the office.
3	office_name		character varying	150	The name given to the office which is also a unique field.
4	nick_name		character varying	50	Another name of the office.
5	registration_date		date	0	The date of registration of the office.
6	currency_code		character varying	12	Foreign key to the table core.currencies.
7	po_box		character varying	128	The Post Box number of the office.
8	address_line_1		character varying	128	The address of the office.
9	address_line_2		character varying	128	The address of the office.
10	street		character varying	50	The name of the street where the office is located.
11	city		character varying	50	The name of the city where the office is located.
12	state		character varying	50	The name of the state where the office is located.
13	zip_code		character varying	24	ZIP code of the office.
14	country		character varying	50	The name of the county where the office is located.
15	phone		character varying	24	Phone number of the office.
16	fax		character varying	24	Fax number of the office.
17	email		character varying	128	E-mail address of the office.
18	url		character varying	50	Web address of the office.
19	registration_number		character varying	24	The registration number of the enntity..
20	pan_number		character varying	24	Permanent Office Number of the entity.
21	allow_transaction_posting		boolean	0
22	parent_office_id		integer	0	Foreign key to the table office.offices.
23	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
24	audit_ts		timestamp with time zone	0	Contains the date and timestamp of the last insert or update action.

Foreign Keys

#	Column Name	Key Name	References
6	currency_code	offices_currency_code_fkey	core.currencies.currency_code
22	parent_office_id	offices_parent_office_id_fkey	office.offices.office_id
23	audit_user_id	offices_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
offices_pkey	postgres	btree	office_id
offices_nick_name_uix	postgres	btree	upper(nick_name::text)
offices_office_name_uix	postgres	btree	upper(office_name::text)
offices_office_code_uix	postgres	btree	upper(office_code::text)

Check Constraints

Constraint Name	Description
offices_check_if_parent_chk CHECK (office.is_parent_office(office_id::integer_strict, parent_office_id::integer_strict) = false AND parent_office_id <> office_id)

Default Values

#	Column Name	Default
1	office_id	nextval('office.offices_office_id_seq'::regclass)
21	allow_transaction_posting	true
24	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description