Environmental-License-System

Tables (6)

documents

  • id — BIGSERIAL
  • permit_item_id — BIGINT — Foreign key → permit_items.id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • file_type — VARCHAR(50) — NOT NULL
  • uploaded_by — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

notifications

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • permit_item_id — BIGINT — Foreign key → permit_items.id — NOT NULL
  • message — VARCHAR(500) — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • notify_type — VARCHAR(10) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

permit_history

  • id — BIGSERIAL
  • permit_item_id — BIGINT — Foreign key → permit_items.id — NOT NULL
  • changed_by — BIGINT — Foreign key → users.id — NOT NULL
  • change_type — VARCHAR(50) — NOT NULL
  • before_value — TEXT
  • after_value — TEXT
  • changed_at — TIMESTAMP — NOT NULL

permit_items

  • id — BIGSERIAL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • permit_type — VARCHAR(100) — NOT NULL
  • permit_number — VARCHAR(100)
  • authority — VARCHAR(200)
  • application_date — DATE
  • acquisition_date — DATE
  • expiry_date — DATE
  • status — VARCHAR(20) — NOT NULL
  • manager_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

projects

  • id — BIGSERIAL
  • name — VARCHAR(200) — NOT NULL
  • facility_type — VARCHAR(50) — NOT NULL
  • location — VARCHAR(200)
  • start_date — DATE
  • end_date — DATE
  • status — VARCHAR(20) — NOT NULL
  • manager_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — BIGSERIAL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL