렌터카플랫폼_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