123
Tables (10)
account
- account_id — INT — NOT NULL
- account_number — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- balance — VARCHAR(50) — NOT NULL
authentication
- authentication_id — INT — NOT NULL
- name — DATE — NOT NULL
- email — VARCHAR(50) — NOT NULL
- pin_number — VARCHAR(50) — NOT NULL
bank
- bank_id — INT — NOT NULL
- bank_code — VARCHAR(50) — NOT NULL
- account_id — VARCHAR(50) — NOT NULL
classification
- classification_code — INT — NOT NULL
- classification_name — DATE — NOT NULL
employee_sub
- employee_id — INT — NOT NULL
- name — VARCHAR(30) — NOT NULL
- employment_type — BOOLEAN — NOT NULL
- phone_number — VARCHAR(30) — NOT NULL
- payment_date — TINYINT — NOT NULL
- salary — INT — NOT NULL
- account_number — VARCHAR(50) — NOT NULL
- president_id — INT — NOT NULL
pay_statement
- ps_id — INT — NOT NULL
- url — VARCHAR(150) — NOT NULL
- issuance_date — DATE — NOT NULL
- employee_id — INT — NOT NULL
president_sub
- president_id — INT — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- account_number — VARCHAR(50) — NOT NULL
salary
- salary_id — INT — NOT NULL
- transfer_date — DATE — NOT NULL
- amount — INT — NOT NULL
- president_id — INT — NOT NULL
- employee_id — INT — NOT NULL
transaction_history
- th_id — UUID — NOT NULL
- transaction_date — DATE — NOT NULL
- deposit — INT — NOT NULL
- withdrawal — INT — NOT NULL
- transaction_type — VARCHAR(50) — NOT NULL
- classification_code — VARCHAR(50) — NOT NULL
- account_id — VARCHAR(50) — NOT NULL
working
- working_id — INT — NOT NULL
- work_day — DATE — NOT NULL
- work_duration — FLOAT
- start_time — FLOAT — NOT NULL
- end_time — FLOAT
- employee_id — INT — NOT NULL