fsffsfsfs

Tables (8)

branch (Untitled3)

  • branch_no (Key) — Primary key — NOT NULL
  • head_no (Key2) — Foreign key → head.head_no — NOT NULL

customer (Untitled8)

  • customer_no (Key) — Primary key — NOT NULL

head (Untitled)

  • head_no (Key) — Primary key — NOT NULL

manager (Untitled2)

  • manager_no (Key) — Primary key — NOT NULL
  • head_no (Key2) — Foreign key → head.head_no — NOT NULL

membership (Untitled5)

  • mmebers_no (Key) — Primary key — NOT NULL

notice (Untitled4)

  • notice_no (Key) — Primary key — NOT NULL
  • manager_no (Key2) — Foreign key → manager.manager_no — NOT NULL

payment (Untitled6)

  • pay_no (Key) — Primary key — NOT NULL
  • customer_no (Key3) — Foreign key → customer.customer_no — NOT NULL
  • mmebers_no (Key2) — Foreign key → membership.mmebers_no — NOT NULL

payment_history (Untitled7)

  • payH_no (Key) — Primary key — NOT NULL
  • pay_no (Key2) — Foreign key → payment.pay_no — NOT NULL
  • customer_no (Key3) — Foreign key → payment.customer_no — NOT NULL