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