HRBANK

Tables (6)

tbl_backup_history

  • Key — BIGSERIAL — Primary key — NOT NULL
  • created_at — TIMESTAMPZ — NOT NULL
  • worker — VARCHAR — NOT NULL
  • started_at — TIMESTAMPZ — NOT NULL
  • ended_at — TIMESTAMPZ — NOT NULL
  • status — VARCHAR — NOT NULL
  • file_id — BIGSERIAL

tbl_change_log

  • Key — BIGSERIAL — Primary key — NOT NULL
  • employee_id — BIGSERIAL — NOT NULL
  • changed_at — TIMESTAMPZ — NOT NULL
  • changed_ip — VARCHAR(50) — NOT NULL
  • type — VARCHAR — NOT NULL
  • created_at — TIMESTAMPZ — NOT NULL
  • memo — TEXT

tbl_changed_detail

  • Key — BIGSERIAL — Primary key — NOT NULL
  • change_log_id — BIGSERIAL — NOT NULL
  • field_name — VARCHAR — NOT NULL
  • old_value — VARCHAR
  • new_value — VARCHAR
  • created_at — TIMESTAMPZ — NOT NULL

tbl_department

  • id — BiGSERIAL — Primary key — NOT NULL
  • name — VARCHAR — NOT NULL
  • description — VARCHAR — NOT NULL
  • established_date — DATE — NOT NULL
  • created_at — TIMESTAMPZ — NOT NULL
  • updated_at — TIMESTAMPZ

tbl_employees

  • id — BIGSERIAL — Primary key — NOT NULL
  • Key — BIGSERIAL
  • department_id — BiGSERIAL — NOT NULL
  • name — VARCHAR — NOT NULL
  • email — VARCHAR — NOT NULL
  • eployee_number — VARCHAR — NOT NULL
  • position — VARCHAR — NOT NULL
  • hire_date — DATE — NOT NULL
  • status — VARCHAR — NOT NULL
  • created_at — TIMESTAMPZ — NOT NULL
  • updated_at — TIMESTAMPZ

tbl_file_metadata

  • Key — BIGSERIAL — Primary key — NOT NULL
  • created_at — TIMESTAMPZ — NOT NULL
  • file_name — VARCHAR — NOT NULL
  • content_type — VARCHAR — NOT NULL
  • size — BIGINT — NOT NULL