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 (거래상태)