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