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