Prime2.0
Tables (15)
AccessInfo (access_info.)
- id — Int — Primary key — NOT NULL
- carMaster (car_master_id) — Int — Foreign key → CarMaster.id — NOT NULL
- registerPath (register_path) — Enum
- authenticationDate (authentication_date) — DateTime
- refreshToken (refresh_token) — String
- firebaseToken (firebase_token) — String
- loginAt (login_at) — DateTime
- recentAccessAt (recent_access_at) — DateTime
- Field
AgencyCarMaster (agency_car_master)
- id — Int — Primary key — NOT NULL
- carMaster (car_master_id) — Int — Foreign key → CarMaster.id — NOT NULL
CarMaster (members)
- id — Int — Primary key — NOT NULL
- carMasterRole (car_master_role_id) — Int — Foreign key → CarMasterRole.id — NOT NULL
- cmId (cm_id) — String
- memberId (member_id) — String
- residentRegistrationNumber (resident_registration_number) — String
- phone — String
- phoneType (phone_type) — String
- password — String
- name — String
- gender — Enum
- birthday — DateTime
- email — String
- position — String
- status — Enum
- chabotPremium (chabot_premium) — DateTime
- statusMemo (status_memo) — String
- recommendedChabotMember (recommended_chabot_member) — String
- profilePath (profile_path) — String
- businessCardPath (business_card_path) — String
CarMasterRole (car_master_roles)
- id — Int — Primary key — NOT NULL
- name — String
- Field
ChabotCarMaster (chabot_car_master)
- id — Int — Primary key — NOT NULL
- carMaster (car_master_id) — Int — Foreign key → CarMaster.id — NOT NULL
Company (companies)
- id — Int — Primary key — NOT NULL
- name — Enm
- logoPath (logo_path) — String
CompanyManager (company_managers)
DomesticCarMaster (domestic_car_master)
- id — Int — Primary key — NOT NULL
- carMaster (car_master_id) — Int — Foreign key → CarMaster.id — NOT NULL
ImportedCarMaster (imported_car_masters)
- id — Int — Primary key — NOT NULL
- carMaster (car_master_id) — Int — Foreign key → CarMaster.id — NOT NULL
InforamationGatheringInfo (information_gathering_info)
- id — Int — Primary key — NOT NULL
- carMaster (car_master_id) — Int — Foreign key → CarMaster.id — NOT NULL
- privacy — Boolean
- service — Boolean
- choice — Boolean
InsurancePlanner (insurance_planners)
- id — Int — Primary key — NOT NULL
- carMaster (car_master_id) — Int — Foreign key → CarMaster.id — NOT NULL
MemberHistory (member_histories)
- id — Int — Primary key — NOT NULL
- carMaster (car_master_id) — Int — Foreign key → CarMaster.id — NOT NULL
- type — Enum
- contents — String
- registerPath (register_path) — Enum
PaymentInfo (payment_info)
- id — Int — Primary key — NOT NULL
- carMaster (car_master_id) — Int — Foreign key → CarMaster.id — NOT NULL
- status — Enum
- paymentType (payment_type) — Enum
- paymentMethod (payment_method) — Enum
- cumulativePayment (cumulative_payment) — Int
- paymentAt (payment_at) — DateTime
- nextPaymentAt (next_payment_at) — DateTime
- expiredAt (expired_at) — DateTime
UseServiceInfo (use_service_info)
- id — Int — Primary key — NOT NULL
- carMaster (car_master_id) — Int — Foreign key → CarMaster.id — NOT NULL
- vip — Boolean
- prime — Boolean
- mutualAid (mutual_aid) — Boolean
UsedCarMaster (used_car_master)
- id — Int — Primary key — NOT NULL
- carMaster (car_master_id) — Int — Foreign key → CarMaster.id — NOT NULL
- employeeNumber (employee_number) — String
- idCardFrontPath (id_card_front_path) — String
- idCardBackPath (id_card_back_path) — String
- Field