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