phoneStore

Tables (3)

Customer (고객)

  • customer_id (고객id) — int — Primary key — NOT NULL
  • name (고객명) — string
  • budget (예산) — double

Phone (핸드폰)

  • phone_id (핸드폰id) — int — Primary key — NOT NULL
  • price (가격) — double

PhoneStroe (핸드폰 대리점)

  • phone_store_id (핸드폰대리점id) — int — Primary key — NOT NULL
  • phone_id (핸드폰id) — int — Foreign key → Phone.phone_id — NOT NULL
  • register_payment (요금제,약정)
  • discount_promotion (할인율)
  • customer_id (고객id) — int — Foreign key → Customer.customer_id — NOT NULL