fisa06test
Tables (3)
customer (customers)
- c_id (고객id) — int — Primary key — NOT NULL
- Field (고객이름) — varchar(20)
- Field2 (멤버십 등급)
- Field3 (공동현관 출입법)
- Field
- Field2
- Field4
- Field5
- Field6
order
- Key (주문번호) — int — Primary key — NOT NULL
- Key (주문한 고객) — int — Primary key — NOT NULL
- Key2 (주문한 상품) — Primary key — NOT NULL
- Field (상품)
- Field2
- Field3
- Field4
product
- Key (상품id) — int — Primary key — NOT NULL
- Field (상품명) — varchar(20)
- Field2
- Field3
- Field4