렌터카플랫폼_12
테이블 (8)
Contract (Untitled3)
- contractId (Key) — serial — 기본 키 — NOT NULL
- usageId (Key2) — serial — 외래 키 → Usage.usageId — NOT NULL
- customerId (Key1) — serial — 외래 키 → Usage.customerId — NOT NULL
- contractDate (Field) — timestamp
- contractType (Field2) — boolean
- contractMonth (Field3) — integer
- rentalAmount (Field4) — integer
- contractState (Field5) — text
Customer (Untitled)
- customerId (Key1) — serial — 기본 키 — NOT NULL
- name (Field2) — text
- email (Field3) — text
- customerPw (Field4) — text — NOT NULL
- phone (Field5) — text
- driveNum (Field6) — text
- driveScore (Field7) — integer
- enrollDay (Field8) — timestamp
Feedback (Untitled6)
- feedbackId (Key) — serial — 기본 키 — NOT NULL
- usageId (Key2) — serial — 외래 키 → Usage.usageId — NOT NULL
- customerId (Key1) — serial — 외래 키 → Usage.customerId — NOT NULL
- feedbackDay (Field) — timestamp
- feedbackScore (Field2) — integer
- feedbackDetail (Field3) — text
Insurance (Untitled4)
- insuranceId (Key) — serial — 기본 키 — NOT NULL
- contractId (Key2) — serial — 외래 키 → Contract.contractId — NOT NULL
- usageId (Key22) — serial — 외래 키 → Contract.usageId — NOT NULL
- customerId (Key1) — serial — 외래 키 → Contract.customerId — NOT NULL
- insuranceName (Field) — text
- insuranceType (Field2) — text
- insuranceAmount (Field3) — integer
- insuranceDate (Field4) — timestamp
Recommendation (Untitled5)
- recommendId (Key) — serial — 기본 키 — NOT NULL
- customerId (Key1) — serial — 외래 키 → Customer.customerId — NOT NULL
- recommendDay (Field) — timestamp
- recommendType (Field2) — boolean
- recommendDetail (Field3) — text
- recommendChosen (Field4) — boolean
TravelCourse (Untitled7)
- travelId (Key) — serial — 기본 키 — NOT NULL
- usageId (Key2) — serial — 외래 키 → Usage.usageId — NOT NULL
- customerId (Key1) — serial — 외래 키 → Usage.customerId — NOT NULL
- travelDay (Field) — timestamp
- travelName (Field2) — text
- travelDetail (Field3) — text
Usage
- usageId (Key) — serial — 기본 키 — NOT NULL
- customerId (Key1) — serial — 외래 키 → Customer.customerId — NOT NULL
- selectType (Field2) — boolean
- startDay (Field3) — timestamp
- endDay (Field4) — timestamp
- state (Field5) — text
- putOption (Field6) — json
Vehicle (Untitled2)
- carId (Key) — serial — 기본 키 — NOT NULL
- carName (Field) — text
- carType (Field2) — text
- carEngine (Field3) — text
- carColor (Field4) — text
- carOption (Field5) — text
- carState (Field6) — text
- carEnroll (Field7) — timestamp