portal
Tables (3)
companies
- company_id — Serial — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- code — VARCHAR(20) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
departments
- department_id — SERIAL
- division_id — INTEGER — NOT NULL
- name — VARCHAR(100) — NOT NULL
- code — VARCHAR(20) — NOT NULL
- manager_id — INTEGER
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- UNIQUE(division_id, — code)
divisions
- company_id (company_id2) — Serial — Foreign key → companies.company_id — NOT NULL
- division_id — SERIAL
- company_id — INTEGER — NOT NULL
- name — VARCHAR(100) — NOT NULL
- code — VARCHAR(20) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- UNIQUE(company_id, — code)
- company_id (company_id3) — Serial — Foreign key → companies.company_id — NOT NULL