CarERD

Tables (4)

Buyer ((구매자))

  • id (PK) — Long — Primary key — NOT NULL
  • CarDealership_id (FK) — Long — Foreign key → CarDealership.id — NOT NULL
  • name (Field) — String
  • age (Field2) — int
  • email (Field3) — String
  • address (Field4) — String
  • phoneNumber (Field5) — String

Car ((자동차 목록))

  • id (PK) — Long — Primary key — NOT NULL
  • CarDealership_id (FK) — Long — Foreign key → CarDealership.id — NOT NULL
  • name (Field) — String
  • price (Field2) — int
  • quantity (Field3) — Long

CarDealership ((자동차 대리점))

  • id (PK) — Long — Primary key — NOT NULL
  • location (Field) — String
  • name (Field2) — String

Purchase ((구매 내역))

  • id (PK) — Long — Primary key — NOT NULL
  • Buyer_id (FK) — Long — Foreign key → Buyer.id — NOT NULL
  • Car_id (FK2) — Long — Foreign key → Car.id — NOT NULL
  • date (Field) — Date