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