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