Prime

Tables (122)

BranchAndBrand

  • branch_id — int(11) — Foreign key → branches.id — NOT NULL
  • brand_id — int(11) — Foreign key → brands.id — NOT NULL

ClientMemberAndCompanyMemberEmployee

  • client_member_id — int(11) — Foreign key → client_members.id — NOT NULL
  • company_member_employee_id — int(11) — Foreign key → company_member_employees.id — NOT NULL

ClientMemberAndCompletedFunding

  • client_member_id — int(11) — Foreign key → client_members.id — NOT NULL
  • completed_funding_id — int(11) — Foreign key — NOT NULL

ClientMemberAndCompletedSales

  • client_member_id — int(11) — Foreign key → client_members.id — NOT NULL
  • completed_sales_id — int(11) — Foreign key — NOT NULL

ClientMemberAndInsurance

  • client_member_id — int(11) — Foreign key → client_members.id — NOT NULL
  • insurance_id — int(11) — Foreign key — NOT NULL

ClientMemberAndMember

  • car_master_id — int(11) — Foreign key — NOT NULL
  • client_member_id — int(11) — Foreign key → client_members.id — NOT NULL

CompanyAndBrand

  • brand_id — int(11) — Foreign key → brands.id — NOT NULL
  • company_id — int(11) — Foreign key → companies.id — NOT NULL

CompanyMemberAndCompanyMemberRole

  • company_member_id — int(11) — Foreign key → company_members.id — NOT NULL
  • company_member_role_id — int(11) — Foreign key → company_member_roles.id — NOT NULL

NewsFeedFilterAndBrandTable

  • brand_id — int(11) — Foreign key → brands.id — NOT NULL
  • news_feed_id — int(11) — Foreign key — NOT NULL

NewsFeedFilterAndCarMasterRoleTable

  • car_master_role_id — int(11) — Foreign key → car_master_roles.id — NOT NULL
  • news_feed_id — int(11) — Foreign key — NOT NULL

NewsFeedFilterAndCompanyTable

  • company_id — int(11) — Foreign key → companies.id — NOT NULL
  • news_feed_id — int(11) — Foreign key — NOT NULL

NewsFeedFilterAndLocationTable

  • location_id — int(11) — Foreign key — NOT NULL
  • news_feed_id — int(11) — Foreign key — NOT NULL

PartnershipCompanyAndPartnershipRole

  • partnership_company_id — int(11) — Foreign key — NOT NULL
  • partnership_role_id — int(11) — Foreign key — NOT NULL

access_info

  • id — int(11) — Primary key — NOT NULL
  • register_path — varchar(191) — NOT NULL
  • authentication_date — datetime(3)
  • refresh_token — mediumtext
  • firebase_token — mediumtext
  • login_at — datetime(3)
  • recent_access_at — datetime(3)
  • stopped_ad — datetime(3)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • car_master_id — int(11) — Foreign key

accounts

  • id — int(11) — Primary key — NOT NULL
  • isMain — tinyint(1) — NOT NULL
  • type — varchar(191)
  • ownerType — varchar(191) — NOT NULL
  • account_number — mediumtext — NOT NULL
  • accountName — mediumtext
  • account_holder — mediumtext
  • accountImageSrc — mediumtext
  • resident_registration_number — mediumtext
  • IDCardFrontImageSrc — mediumtext
  • IDCardBackImageSrc — mediumtext
  • business_license_number — mediumtext
  • businessLicenseImageSrc — mediumtext
  • email — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • company_member_id — int(11) — Foreign key → company_members.id
  • chabot_member_id — int(11) — Foreign key → chabot_members.id
  • bank_id — int(11) — Foreign key → banks.id
  • company_id — int(11) — Foreign key → companies.id
  • branch_id — int(11) — Foreign key → branches.id
  • car_master_id — int(11) — Foreign key
  • mutual_cooperative_info_id — int(11) — Foreign key

agency_car_masters

  • id — int(11) — Primary key — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • car_master_id — int(11) — Foreign key

banks

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • code — mediumtext
  • type — varchar(191) — NOT NULL
  • logo_path — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)

branch_images

  • id — int(11) — Primary key — NOT NULL
  • key — mediumtext — NOT NULL
  • fileName — mediumtext — NOT NULL
  • size — int(11) — NOT NULL
  • type — mediumtext — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • branch_id — int(11) — Foreign key → branches.id

branches

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • address — mediumtext
  • registred_address — mediumtext
  • is_headquarters — tinyint(1)
  • businessType — varchar(191)
  • business_license_number — mediumtext
  • business_license_image_src — mediumtext
  • corporate_registration_number — mediumtext
  • tax_classification — varchar(191)
  • contact — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • company_id — int(11) — Foreign key → companies.id
  • union_society_id — int(11) — Foreign key
  • sales_complex_id — int(11) — Foreign key
  • location_id — int(11) — Foreign key

brands

  • id — int(11) — Primary key — NOT NULL
  • ko_name — mediumtext — NOT NULL
  • eng_name — mediumtext — NOT NULL
  • emeye_name — mediumtext
  • damoa_name — mediumtext
  • logo_path — mediumtext
  • order_number — int(11)
  • nationality — varchar(191) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)

car_master_images

  • id — int(11) — Primary key — NOT NULL
  • key — mediumtext — NOT NULL
  • fileName — mediumtext
  • size — int(11)
  • type — mediumtext
  • category — varchar(191) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • car_master_id — int(11) — Foreign key

car_master_roles

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)

cash_back

  • id — int(11) — Primary key — NOT NULL
  • organizer — mediumtext — NOT NULL
  • explanation_text — mediumtext
  • logo_path — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • partnership_company_id — int(11) — Foreign key
  • partner_id — int(11) — Foreign key
  • chabot_member_id — int(11) — Foreign key → chabot_members.id

cash_back_application_files

  • id — int(11) — Primary key — NOT NULL
  • key — mediumtext — NOT NULL
  • file_name — mediumtext — NOT NULL
  • type — mediumtext — NOT NULL
  • size — int(11) — NOT NULL
  • category — varchar(191) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • cash_back_application_id — int(11) — Foreign key → cash_back_applications.id

cash_back_application_histories

  • id — int(11) — Primary key — NOT NULL
  • type — varchar(191) — NOT NULL
  • contents — mediumtext — NOT NULL
  • register_path — varchar(191) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • cash_back_application_id — int(11) — Foreign key → cash_back_applications.id
  • partner_id — int(11) — Foreign key
  • chabot_member_id — int(11) — Foreign key → chabot_members.id

cash_back_applications

  • id — int(11) — Primary key — NOT NULL
  • status — varchar(191) — NOT NULL
  • down_payment — int(11) — NOT NULL
  • car_maker — mediumtext
  • car_model — mediumtext
  • payment_due_date — datetime(3) — NOT NULL
  • memo_list — mediumtext
  • unable_to_proceed_reason — mediumtext
  • created_from — varchar(191)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • partner_id — int(11) — Foreign key
  • account_id — int(11) — Foreign key → accounts.id
  • brand_id — int(11) — Foreign key → brands.id
  • newcar_estimate_id — int(11) — Foreign key
  • cash_back_condition_id — int(11) — Foreign key → cash_back_conditions.id
  • client_master_id — int(11) — Foreign key → clients.id
  • chabot_member_id — int(11) — Foreign key → chabot_members.id
  • car_master_id — int(11) — Foreign key

cash_back_conditions

  • id — int(11) — Primary key — NOT NULL
  • start_range — int(11) — NOT NULL
  • end_range — int(11) — NOT NULL
  • car_master_rate — decimal(65, 30) — NOT NULL
  • client_rate — decimal(65, 30) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • cash_back_detail_id — int(11) — Foreign key → cash_back_details.id

cash_back_details

  • id — int(11) — Primary key — NOT NULL
  • product_name — mediumtext — NOT NULL
  • product_path_url — mediumtext
  • enforcement_month — datetime(3) — NOT NULL
  • limit — int(11) — NOT NULL
  • chabot_fee_rate — decimal(65, 30) — NOT NULL
  • explanation_text — mediumtext
  • warning_text — mediumtext
  • card_type — varchar(191)
  • type — varchar(191)
  • locationType — varchar(191)
  • is_commission_hidden — tinyint(1)
  • is_interest_rate_hidden — tinyint(1)
  • is_available_alarm_talk — tinyint(1) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • cash_back_id — int(11) — Foreign key → cash_back.id

cash_info

  • id — int(11) — Primary key — NOT NULL
  • amount — int(11) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • car_master_id — int(11) — Foreign key

centers

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)

chabot_anonymous_board

  • id — int(11) — Primary key — NOT NULL
  • title — mediumtext — NOT NULL
  • body — mediumtext — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL

chabot_anonymous_contents

  • id — int(11) — Primary key — NOT NULL
  • contents — mediumtext — NOT NULL
  • is_public — tinyint(1)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL

chabot_car_masters

  • id — int(11) — Primary key — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • car_master_id — int(11) — Foreign key

chabot_member_access_infos

  • id — int(11) — Primary key — NOT NULL
  • refresh_token — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • chabot_member_id — int(11) — Foreign key → chabot_members.id

chabot_member_ids

  • id — int(11) — Primary key — NOT NULL
  • member_id — int(11)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • chabot_member_id — int(11) — Foreign key → chabot_members.id

chabot_members

  • id — int(11) — Primary key — NOT NULL
  • notification_permission — tinyint(1) — NOT NULL
  • channelTalkManagerId — int(11)
  • name — mediumtext — NOT NULL
  • nickname — mediumtext — NOT NULL
  • phone — mediumtext — NOT NULL
  • sub_phone — mediumtext
  • password — mediumtext — NOT NULL
  • gender — varchar(191) — NOT NULL
  • email — mediumtext — NOT NULL
  • status — varchar(191) — NOT NULL
  • duty — varchar(191) — NOT NULL
  • last_assign_date — datetime(3)
  • entered_at — datetime(3)
  • resignation_at — datetime(3)
  • profile_path — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • center_id — int(11) — Foreign key → centers.id
  • position_id — int(11) — Foreign key
  • department_id — int(11) — Foreign key
  • office_id — int(11) — Foreign key

client_anniversary_date

  • id — int(11) — Primary key — NOT NULL
  • anniversary_type — varchar(191) — NOT NULL
  • etc_type_name — mediumtext
  • date — datetime(3) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • client_id — int(11) — Foreign key → clients.id

client_interested_vehicles

  • id — int(11) — Primary key — NOT NULL
  • car_db_grade_id — int(11) — NOT NULL
  • hopePurchaseDate — varchar(191) — NOT NULL
  • maker — mediumtext
  • model — mediumtext
  • grade — mediumtext
  • purpose — mediumtext — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • client_id — int(11) — Foreign key → clients.id

client_members

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • phone — mediumtext — NOT NULL
  • resident_registration_number — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)

client_memos

  • id — int(11) — Primary key — NOT NULL
  • memo — mediumtext — NOT NULL
  • notification_time — datetime(3)
  • client_memo_notification_status — varchar(191) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • client_id — int(11) — Foreign key → clients.id

client_owning_vehicles

  • id — int(11) — Primary key — NOT NULL
  • grade_id — int(11) — NOT NULL
  • maker — mediumtext
  • model — mediumtext
  • grade — mediumtext
  • image_path — mediumtext
  • driving_distance — int(11)
  • vehicle_number — mediumtext
  • vehicle_model_year — int(11)
  • forwarding_price — int(11)
  • puchase_date — datetime(3) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • client_id — int(11) — Foreign key → clients.id
  • brand_id — int(11) — Foreign key → brands.id

clients

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • nickname — mediumtext
  • phone — mediumtext — NOT NULL
  • family_info — varchar(191)
  • job_type — varchar(191)
  • company — mediumtext
  • position — mediumtext
  • salary — mediumtext
  • preference_items — mediumtext
  • email — mediumtext
  • gender — varchar(191)
  • address — mediumtext
  • hopeVehiclePrice — mediumtext
  • birthday — datetime(3)
  • year — int(11)
  • month — int(11)
  • date — int(11)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • car_master_id — int(11) — Foreign key
  • brand_id — int(11) — Foreign key → brands.id

companies

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • type — varchar(191) — NOT NULL
  • logo_path — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)

company_completed_sales

  • id — int(11) — Primary key — NOT NULL
  • sale_price — int(11) — NOT NULL
  • sale_date — datetime(3) — NOT NULL
  • commission_amount — int(11) — NOT NULL
  • commission_pay_day — datetime(3)
  • chabot_fee — int(11) — NOT NULL
  • created_from — varchar(191)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • company_usedcar_estimate_id — int(11) — Foreign key
  • cahbot_member_id — int(11) — Foreign key → chabot_members.id
  • company_member_employee_id — int(11) — Foreign key → company_member_employees.id

company_managers

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • phone — mediumtext — NOT NULL
  • position — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • company_id — int(11) — Foreign key → companies.id

company_member_employees

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • employeeNumber — mediumtext
  • phone — mediumtext — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • company_member_id — int(11) — Foreign key → company_members.id

company_member_managers

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • phone — mediumtext — NOT NULL
  • password — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • chabot_member_id — int(11) — Foreign key → company_members.id

company_member_roles

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL

company_members

  • id — int(11) — Primary key — NOT NULL
  • cmId — mediumtext
  • name — mediumtext — NOT NULL
  • is_partner — tinyint(1) — NOT NULL
  • registered_at — datetime(3)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • stopped_at — datetime(3)
  • deleted_at — datetime(3)
  • chabot_member — int(11) — Foreign key → chabot_members.id

company_usedcar_consulting

  • id — int(11) — Primary key — NOT NULL
  • status — varchar(191) — NOT NULL
  • vehicle_number — mediumtext
  • is_contact_now — tinyint(1)
  • contact_start_hour — int(11)
  • contact_end_hour — int(11)
  • created_at — datetime(3) — NOT NULL
  • created_from — varchar(191)
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • company_member_employee_id — int(11) — Foreign key → company_member_employees.id
  • employee_client_id — int(11) — Foreign key
  • company_usedcar_estimate_id — int(11) — Foreign key

company_usedcar_contract_files

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • nickname — mediumtext — NOT NULL
  • type — mediumtext — NOT NULL
  • size — int(11) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • company_usedcar_estimate_id — int(11) — Foreign key → company_usedcar_estimates.id

company_usedcar_estimates

  • id — int(11) — Primary key — NOT NULL
  • status — varchar(191) — NOT NULL
  • nickname — mediumtext
  • vehicle_number — mediumtext — NOT NULL
  • vehicle_identification_number — mediumtext
  • owner_name — mediumtext
  • register_date — datetime(3)
  • forwarding_price — int(11)
  • pre_estimate_price — int(11)
  • estimate_price — int(11)
  • driving_distance — int(11)
  • vehicle_model_year — int(11)
  • forwarding_scheduled_date — datetime(3)
  • location — varchar(191)
  • city — mediumtext
  • region — mediumtext
  • usage — mediumtext
  • customer_wish_price — int(11)
  • hope_fee — int(11)
  • cancelReason — mediumtext
  • imagePath — mediumtext
  • created_from — varchar(191)
  • enterpreneur_type — varchar(191)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • employee_client_id — int(11) — Foreign key → employee_clients.id
  • usedcarConsulting — int(11) — Foreign key
  • company_member_employee_id — int(11) — Foreign key
  • account_id — int(11) — Foreign key
  • chabot_member_id — int(11) — Foreign key

company_usedcar_infos

  • id — int(11) — Primary key — NOT NULL
  • maker — mediumtext — NOT NULL
  • series — mediumtext — NOT NULL
  • model — mediumtext — NOT NULL
  • grade — mediumtext
  • gearbox — mediumtext
  • fuel_type — mediumtext
  • sun_loop — tinyint(1)
  • air_sheet — tinyint(1)
  • smartKey — tinyint(1)
  • navigation — tinyint(1)
  • options — mediumtext
  • color — mediumtext
  • external_condition — int(11)
  • door_condition — int(11)
  • front_fender — int(11)
  • back_fender — int(11)
  • bonnet — tinyint(1)
  • trunk — tinyint(1)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • company_usedcar_estimate_id — int(11) — Foreign key → company_usedcar_estimates.id

company_usedcar_registration_files

  • id — int(11) — Primary key — NOT NULL
  • key — mediumtext — NOT NULL
  • fileName — mediumtext — NOT NULL
  • type — mediumtext — NOT NULL
  • size — int(11) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • company_usedcar_estimate_id — int(11) — Foreign key → company_usedcar_estimates.id

company_usedcar_sale_memos

  • id — int(11) — Primary key — NOT NULL
  • memo — mediumtext — NOT NULL
  • category — varchar(191) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • company_usedcar_estimate_id — int(11) — Foreign key → company_usedcar_estimates.id

completed_funding_files

  • id — int(11) — Primary key — NOT NULL
  • key — mediumtext — NOT NULL
  • file_name — mediumtext — NOT NULL
  • type — mediumtext — NOT NULL
  • size — int(11) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • completed_funding_id — int(11) — Foreign key → completed_fundings.id

completed_fundings

  • id — int(11) — Primary key — NOT NULL
  • vehicle_number — mediumtext
  • type — varchar(191) — NOT NULL
  • status — varchar(191) — NOT NULL
  • funding_price — int(11) — NOT NULL
  • funding_date — datetime(3) — NOT NULL
  • funding_period — int(11)
  • chabot_fee_rate — decimal(65, 30)
  • chabot_fee — int(11)
  • chabot_account_type — varchar(191)
  • agency_fee_rate — decimal(65, 30)
  • agency_fee — int(11)
  • commission_rate — decimal(65, 30)
  • commission_amount — int(11)
  • request_commission_pay_day — datetime(3)
  • commission_pay_day — datetime(3)
  • estimate_image_path — mediumtext
  • contract_formImage_path — mediumtext
  • vehicle_registration_image_path — mediumtext
  • created_from — varchar(191)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • car_master_id — int(11) — Foreign key
  • cahbot_member_id — int(11) — Foreign key
  • refinance_application_id — int(11) — Foreign key
  • partner_id — int(11) — Foreign key
  • installment_condition_id — int(11) — Foreign key
  • cash_back_condition_id — int(11) — Foreign key
  • refinance_condition_id — int(11) — Foreign key
  • cash_back_application_id — int(11) — Foreign key
  • installment_application_id — int(11) — Foreign key

completed_sales

  • id — int(11) — Primary key — NOT NULL
  • sale_price — int(11) — NOT NULL
  • sale_date — datetime(3) — NOT NULL
  • commission_amount — int(11) — NOT NULL
  • commission_pay_day — datetime(3)
  • chabot_fee — int(11) — NOT NULL
  • created_from — varchar(191)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • usedcar_estimate_id — int(11) — Foreign key
  • cahbot_member_id — int(11) — Foreign key
  • car_master_id — int(11) — Foreign key

contents_files

  • id — int(11) — Primary key — NOT NULL
  • key — mediumtext — NOT NULL
  • fileName — mediumtext — NOT NULL
  • size — mediumtext — NOT NULL
  • type — mediumtext — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • contents_id — int(11) — Foreign key → contentses.id

contentses

  • id — int(11) — Primary key — NOT NULL
  • category — varchar(191) — NOT NULL
  • eventStatus — varchar(191)
  • title — mediumtext — NOT NULL
  • body — mediumtext — NOT NULL
  • start_date — datetime(3)
  • end_date — datetime(3)
  • stopped_at — datetime(3)
  • announcement_at — datetime(3)
  • selected_personnel_count — int(11)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • earnPointCategory — int(11) — Foreign key → earn_point_categories.id
  • chabot_member_id — int(11) — Foreign key

departments

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • center_id — int(11) — Foreign key

domestic_car_masters

  • id — int(11) — Primary key — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • car_master_id — int(11) — Foreign key

earn_cash_categories

  • id — int(11) — Primary key — NOT NULL
  • contents — mediumtext — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)

earn_cash_histories

  • id — int(11) — Primary key — NOT NULL
  • remaining_cash — int(11) — NOT NULL
  • status — varchar(191) — NOT NULL
  • expired_at — datetime(3)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • car_master_id — int(11) — Foreign key
  • cash_category_id — int(11) — Foreign key → earn_cash_categories.id
  • cash_info_id — int(11) — Foreign key

earn_point_categories

  • id — int(11) — Primary key — NOT NULL
  • contents — mediumtext — NOT NULL
  • amount — int(11) — NOT NULL
  • daily_limit — int(11)
  • type — varchar(191) — NOT NULL
  • status — varchar(191) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)

earn_point_histories

  • id — int(11) — Primary key — NOT NULL
  • remaining_points — int(11) — NOT NULL
  • status — varchar(191) — NOT NULL
  • expired_at — datetime(3)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • car_master_id — int(11) — Foreign key
  • point_info_id — int(11) — Foreign key
  • point_category_id — int(11) — Foreign key → earn_point_categories.id

employee_clients

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • phone — mediumtext — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • company_member_employee_id — int(11) — Foreign key

event_applications

  • id — int(11) — Primary key — NOT NULL
  • status — varchar(191) — NOT NULL
  • type — varchar(191) — NOT NULL
  • name — mediumtext
  • phone — mediumtext
  • memo — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • carMaster — int(11) — Foreign key
  • contents — int(11) — Foreign key → contentses.id

expenditure_cash_categories

  • id — int(11) — Primary key — NOT NULL
  • contents — mediumtext — NOT NULL
  • type — varchar(191) — NOT NULL
  • amount — int(11) — NOT NULL
  • optionInfo — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)

expenditure_cash_histories

  • id — int(11) — Primary key — NOT NULL
  • reason — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • cash_info_id — int(11) — Foreign key
  • cash_category_id — int(11) — Foreign key → expenditure_cash_categories.id
  • car_master_id — int(11) — Foreign key

expenditure_point_categories

  • id — int(11) — Primary key — NOT NULL
  • contents — mediumtext — NOT NULL
  • type — varchar(191) — NOT NULL
  • amount — int(11) — NOT NULL
  • optionInfo — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)

expenditure_point_histories

  • id — int(11) — Primary key — NOT NULL
  • reason — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • point_info_id — int(11) — Foreign key
  • point_category_id — int(11) — Foreign key → expenditure_point_categories.id
  • car_master_id — int(11) — Foreign key

federations

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)

frequently_asked_question_categories

  • id — int(11) — Primary key — NOT NULL
  • name — mediumtext — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)

frequently_asked_questions

  • id — int(11) — Primary key — NOT NULL
  • question — mediumtext — NOT NULL
  • answer — mediumtext — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • chabot_member_id — int(11) — Foreign key
  • frequently_asked_question_category_id — int(11) — Foreign key → frequently_asked_question_categories.id

imported_car_masters

  • id — int(11) — Primary key — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • car_master_id — int(11) — Foreign key

information_gathering_info

  • id — int(11) — Primary key — NOT NULL
  • privacy — datetime(3)
  • service — datetime(3)
  • choice — datetime(3)
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • car_master_id — int(11) — Foreign key

installment

  • id — int(11) — Primary key — NOT NULL
  • organizer — mediumtext — NOT NULL
  • logo_path — mediumtext
  • explanation_text — mediumtext
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • partnership_company_id — int(11) — Foreign key
  • chabot_member_id — int(11) — Foreign key

installment_application_files

  • id — int(11) — Primary key — NOT NULL
  • key — mediumtext — NOT NULL
  • file_name — mediumtext — NOT NULL
  • type — mediumtext — NOT NULL
  • size — int(11) — NOT NULL
  • category — varchar(191) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • installment_application_id — int(11) — Foreign key

installment_application_histories

  • id — int(11) — Primary key — NOT NULL
  • type — varchar(191) — NOT NULL
  • contents — mediumtext — NOT NULL
  • register_path — varchar(191) — NOT NULL
  • created_at — datetime(3) — NOT NULL
  • updated_at — datetime(3) — NOT NULL
  • deleted_at — datetime(3)
  • chabot_memeber_id — int(11) — Foreign key
  • installment_application_id — int(11) — Foreign key

and 42 more tables