CarJini

Tables (6)

Car (차량)

  • Key — Primary key — NOT NULL
  • brand (제조사) — String
  • name (차종) — String

Car Chat (차량 채팅)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • carOwnerId (Key2) — Long — Foreign key → Car Owner.Key — NOT NULL

Car Owner (차량 소유자)

  • Key — Long — Primary key — NOT NULL
  • member (사용자) — Long — Foreign key → Member.Key — NOT NULL
  • car (차량) — Long — Foreign key → Car.Key — NOT NULL
  • startDate (관리시작일) — Timestamp
  • startKm (구매 당시 주행거리) — Timestamp
  • nowKm (현재 누적 주행거리) — Timestamp

Maintence History (정비 이력)

  • Key — Primary key — NOT NULL
  • replacementDate (교체 일자) — timestamp
  • replacementKm (교체 주행거리) — Long
  • itemId (소모품 엔티티) — Long — Foreign key → MaintenceItem.Key — NOT NULL
  • carOwnerId (차량 엔티티) — Long — Foreign key → Car Owner.Key — NOT NULL

MaintenceItem (소모품/필터 엔티티)

  • Key — Primary key — NOT NULL
  • name (아이템이름) — String
  • replacementDate (교체주기) — Long
  • replacementKm (교체 주행거리) — Long

Member (사용자)

  • Key — Primary key — NOT NULL
  • name (이름) — String
  • email (이메일) — String
  • profile (프로필 이미지) — String
  • createdAt (생성일자) — timestamp
  • provider (제공자) — String
  • providerId (제공자 아이디) — String