TMS
Tables (5)
attachment
- id — BIGSERIAL — Primary key — NOT NULL
- domain_type — VARCHAR(30) — NOT NULL
- domain_id — BIGINT — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- uploaded_by — BIGINT — Foreign key → users.id — NOT NULL
- uploaded_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- is_deleted — BOOLEAN — NOT NULL
change_log
- id — BIGSERIAL — Primary key — NOT NULL
- domain_type — VARCHAR(30) — NOT NULL
- domain_id — BIGINT — NOT NULL
- field_name — VARCHAR(50) — NOT NULL
- old_value — TEXT
- new_value — TEXT
- changed_by — BIGINT — Foreign key → users.id — NOT NULL
- changed_at — TIMESTAMP — NOT NULL
commercial_line
- id — BIGSERIAL — Primary key — NOT NULL
- line_type — VARCHAR(20) — NOT NULL
- carrier — VARCHAR(20)
- product_name — VARCHAR(100)
- service_number — VARCHAR(50)
- access_line_number — VARCHAR(50)
- billing_contract_id — VARCHAR(50)
- contract_start_date — DATE
- contract_end_date — DATE
- address — VARCHAR(200)
- location_type — VARCHAR(10)
- account_type — VARCHAR(20)
- detail_type — VARCHAR(100)
- department — VARCHAR(50)
- manager_name — VARCHAR(50)
- invoice_email — VARCHAR(100)
- status — VARCHAR(10) — NOT NULL
- card_holder_name — VARCHAR(50)
- card_last4 — VARCHAR(4)
- card_expiry — VARCHAR(7)
- memo — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- created_by — BIGINT — Foreign key → users.id
- updated_by — BIGINT — Foreign key → users.id
- deleted_at — TIMESTAMP
- is_deleted — BOOLEAN — NOT NULL
notification
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- message — VARCHAR(200) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
users
- id — BIGSERIAL — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- department — VARCHAR(50)
- role — VARCHAR(20)