car1
Tables (3)
CUSTOMERS (고객)
- CUSTOMER_ID (고객번호) — Primary key — NOT NULL
- FRIST_NAME (이름)
- LAST_NAME (성)
- PHONE_NUMBER (전화번호)
- EMAIL (이메일)
- ADDRESS (주소)
- DATE_OF_BIRTH (생년월일)
- REGISTRATION_DATE (가입일자)
Car1 (차종)
- Car_ID (차종번호) — Primary key — NOT NULL
- MAKE (제조사)
- MODEL (모델명)
- YEAR (연식)
- COLOR (색상)
- PRICE (가격)
SALES (거래)
- SALE_ID (거래번호) — Primary key — NOT NULL
- CUSTOMER_ID (고객번호) — Foreign key → CUSTOMERS.CUSTOMER_ID — NOT NULL
- Car_ID (차종번호) — Foreign key → Car1.Car_ID — NOT NULL
- SALE_DATE (판매일자)
- SALE_PRICE (최종가격)
- PAYMENT_METHOD (결제방법)
- SALES_PERSON (판매담당자)
- STATUS (거래상태)