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