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