bank

Tables (6)

account (Untitled)

  • account_number (Key) — NOTNULL — Primary key — NOT NULL
  • balance (Field4) — NOTNULL
  • type (Field2) — NOTNULL
  • bank_id (Key2) — NOTNULL — Foreign key → bank.bank_id — NOT NULL
  • user_id (int) — NOTNULL — Foreign key → user.user_id — NOT NULL
  • employee_id (Key3) — NOTNULL — Foreign key → employee.employee_id — NOT NULL
  • password (Field5) — NOTNULL
  • interest_rate (Field6) — NOTNULL
  • created_time (Field7) — NOTNULL

bank (Untitled3)

  • bank_id (Key) — NOTNULL — Primary key — NOT NULL
  • name (Field) — NOTNULL
  • address (Field2) — NOTNULL
  • phone_number (Field3) — NOTNULL
  • open_time (Field4) — NOTNULL
  • close_time (Field5) — NOTNULL
  • created_time (Field6) — NOTNULL

employee (Untitled4)

  • employee_id (Key) — NOTNULL — Primary key — NOT NULL
  • name (Field) — NOTNULL
  • position (Field2) — NOTNULL
  • phone_number (Field3) — NOTNULL
  • email (Field4) — NOTNULL
  • bank_id (Key2) — NOTNULL — Foreign key → bank.bank_id — NOT NULL
  • created_time (Field5) — NOTNULL

reservation (Untitled5)

  • reservaion_id (Key) — NOTNULL — Primary key — NOT NULL
  • reservation_time (Field2) — NOTNULL
  • bank_id (Key2) — NOTNULL — Foreign key → bank.bank_id — NOT NULL
  • user_id (int) — NOTNULL — Foreign key → user.user_id — NOT NULL

transaction_history (Untitled2)

  • history_id (Key) — NOTNULL — Primary key — NOT NULL
  • type (Field) — NOTNULL
  • total_amount (Field2) — NOTNULL
  • account_number (Key2) — NOTNULL — Foreign key → account.account_number — NOT NULL
  • amount (Field4) — NOTNULL
  • created_time (Field5) — NOTNULL
  • sender (Field6) — NOTNULL

user

  • user_id (int) — NOTNULL — Primary key — NOT NULL
  • name (Field) — NOTNULL
  • address (Field2) — NOTNULL
  • phone_number (Field3) — NOTNULL
  • email (Field4) — NOTNULL
  • job (Field5) — NOTNULL
  • income (Field6)
  • asset (Field7) — NOTNULL
  • date_of_birth (Field8) — NOTNULL
  • created_time (Field9) — NOTNULL
  • deleted_time (Field10)
  • login_id (Field11) — NOTNULL
  • password (Field12) — NOTNULL