Prime 2.0

Tables (50)

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

  • member_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)
  • member_id — int(11) — Foreign key

accounts

  • id — int(11) — Primary key — NOT NULL
  • isMain — tinyint(1) — NOT NULL
  • type — varchar(191)
  • owner_type — varchar(191) — NOT NULL
  • account_number — mediumtext — NOT NULL
  • account_name — mediumtext
  • account_holder — mediumtext
  • account_image_src — mediumtext
  • resident_registration_number — mediumtext
  • id_card_front_image_src — mediumtext
  • id_card_back_image_src — 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
  • member_id — int(11) — Foreign key
  • branch_id — int(11) — Foreign key → branches.id
  • 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)
  • member_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
  • file_name — 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
  • registered_address — mediumtext
  • is_headquarters — tinyint(1)
  • business_type — 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)
  • member_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
  • member_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)
  • member_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)
  • member_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
  • channel_talk_manager_id — 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
  • notification_permission — tinyint(1) — NOT NULL
  • 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
  • hope_vehicle_price — 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)
  • member_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)
  • chabot_member_id — int(11) — Foreign key → chabot_members.id
  • company_usedcar_estimate_id — int(11) — Foreign key
  • 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
  • employee_number — 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