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