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)