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