rencar: users

Tables (21)

admin

  • id — int(11) — Foreign key → user.id — NOT NULL
  • realname — varchar(255) — NOT NULL
  • contact — varchar(255) — NOT NULL
  • join_year — varchar(5)
  • level — int(2) — NOT NULL
  • department — varchar(30)
  • id (id2) — int(11) — Foreign key → user.id — NOT NULL

auto_mobile_admin

  • id — int(11) — Foreign key → user.id — NOT NULL
  • company_id — int(11) — Foreign key → car_dealerships.id — NOT NULL
  • point — int(15) — NOT NULL
  • accumulated_point — int(15) — NOT NULL
  • id (id2) — int(11) — Foreign key → user.id — NOT NULL

auto_mobile_workers

  • id — int(11) — Foreign key → user.id — NOT NULL
  • worker_type — ENUM — NOT NULL
  • detail_type — int(3)
  • realname — varchar(30) — NOT NULL
  • title — varchar(50) — NOT NULL
  • nickname — varchar(50) — NOT NULL
  • company — varchar(100) — Foreign key → car_dealership_details.id — NOT NULL
  • contact — varchar(30) — NOT NULL
  • business_card_url — varchar(255)
  • id_license_number — varchar(100)
  • bank — int(3)
  • bank_account_number — varchar(100)
  • point — int(15) — NOT NULL
  • accumulated_point — int(15) — NOT NULL
  • withdrawal_request_point — int(11) — NOT NULL
  • car_center_address — varchar(255)
  • recommender_id — int(11) — Foreign key → user.id
  • connected_company_id — int(11) — Foreign key → user.id
  • business_contact — varchar(15)
  • car_dealership_branch_id — int(11) — Foreign key → car_dealership_branches.id
  • id (id2) — int(11) — Foreign key → user.id — NOT NULL

car_dealership_branches

  • id — int(11) — NOT NULL
  • detail_id — int(11) — Foreign key → car_dealership_details.id — NOT NULL
  • branch_no — int(11) — NOT NULL
  • name — varchar(32) — NOT NULL
  • address — varchar(64)
  • contact — varchar(16)
  • location_id — int(11) — Foreign key → location.id

car_dealership_details

  • id — int(11) — NOT NULL
  • car_dealership_id — int(11) — Foreign key → car_dealership_details.id — NOT NULL
  • business_type — ENUM — NOT NULL

car_dealerships

  • id — int(11) — NOT NULL
  • name — varchar(32) — NOT NULL
  • name_kor — varchar(32) — NOT NULL

custom_admin_user

  • id — int(11) — Foreign key → user.id — NOT NULL
  • level — int(2) — NOT NULL
  • realname — varchar(10) — NOT NULL
  • contact — varchar(15)
  • insurance_company_id — int(11) — Foreign key → insurance_companies.id
  • company_name — varchar(20) — 업체명
  • id (id2) — int(11) — Foreign key → user.id — NOT NULL

driver_types

  • id — smallint(6) — NOT NULL
  • name_kor — varchar(16) — NOT NULL

drivers_license

  • id — int(11) — NOT NULL
  • user_id — int(11) — Foreign key → user.id — NOT NULL
  • birth_num — varchar(6)
  • license_number — varchar(20)
  • expiry_date — date
  • issue_date — date
  • created_at — timestamp — NOT NULL
  • is_enabled — tinyint(1) — NOT NULL
  • removed_at — datetime
  • validation_date — date
  • status_id — smallint(6) — Foreign key → drivers_license_status.id — NOT NULL
  • driver_type_id — smallint(6) — Foreign key → driver_types.id — NOT NULL
  • id (id2) — int(11) — Foreign key → user.id — NOT NULL

drivers_license_status

  • id — smallint(6) — NOT NULL
  • name_kor — varchar(16) — NOT NULL
  • code — char(2) — NOT NULL

init_insurance_user

  • company_id — int(11) — Foreign key → insurance_companies.id — NOT NULL
  • realname — varchar(255) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • company — varchar(255)
  • contact — varchar(255) — NOT NULL
  • id — int(11) — NOT NULL
  • field_service_user — tinyint(1) — NOT NULL
  • repair_shop_user — tinyint(1) — NOT NULL
  • repair_shop_name — varchar(100)
  • repair_shop_address — varchar(255)
  • repair_shop_contact — varchar(15)
  • company_registration_num — varchar(10) — 사업자등록번호

insurance_companies

  • id — int(11) — NOT NULL
  • name — varchar(16) — NOT NULL
  • tier — tinyint(1) — NOT NULL
  • sort_priority — tinyint(4) — NOT NULL
  • cost_table_type_id — int(10) — NOT NULL
  • claim_check — tinyint(1) — NOT NULL — 청구검수 필요한 보험사: True
  • claimable — tinyint(1) — NOT NULL — 청구 가능 여부
  • guaranteed — tinyint(4) — NOT NULL — 보증 여부
  • default_cost_table_type_id — int(10) — 기본 보험사 요금표

insurance_company_user

  • id — int(11) — Foreign key → user.id — NOT NULL
  • realname — varchar(255) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • company — varchar(255)
  • title — varchar(255) — NOT NULL
  • contact — varchar(255) — NOT NULL
  • company_id — int(11) — Foreign key → insurance_companies.id — NOT NULL
  • fax — varchar(255)
  • location2_id — int(11) — Foreign key → location.id
  • location1_id — int(11) — Foreign key → location.id — NOT NULL
  • location3_id — int(11) — Foreign key → location.id
  • center — varchar(50)
  • work_part — varchar(50)
  • direct_user — tinyint(1) — NOT NULL
  • id (id2) — int(11) — Foreign key → user.id — NOT NULL

location

  • id — int(11) — NOT NULL
  • class1 — varchar(50) — NOT NULL
  • class2 — varchar(50)
  • location_order — int(2)
  • is_enabled — tinyint(1) — NOT NULL

rent_company_business

  • id — int(11) — NOT NULL
  • created_at — timestamp — NOT NULL
  • is_enabled — tinyint(1) — NOT NULL
  • removed_at — timestamp
  • rent_company_id — int(11) — Foreign key → user.id — NOT NULL
  • business_name — varchar(50) — NOT NULL
  • registration_num — varchar(30) — NOT NULL
  • registration_path — varchar(255) — NOT NULL
  • bank_account_path — varchar(255) — NOT NULL
  • company_address — varchar(200)
  • company_business — varchar(50)
  • company_type — varchar(200)
  • main_business — tinyint(1) — NOT NULL
  • business_cost_table — varchar(255)
  • president_name — varchar(30)
  • popbil_id — varchar(30)
  • manager_name — varchar(30)
  • manager_mail — varchar(30)
  • manager_contact — varchar(30)
  • manager_fax — varchar(30)
  • business_stamp_path — varchar(255)
  • account_name — varchar(50)
  • bank_code — varchar(2)
  • account_num — varchar(100)
  • business_contact — varchar(20)
  • inicis_id — varchar(60)
  • orderer_accept — tinyint(4) — NOT NULL
  • corporation_number — varchar(14) — 법인등록번호
  • is_corporation — tinyint(1) — NOT NULL — 사업자 구분(법인 유무)
  • is_head_office — tinyint(1) — 사업장 형태(본사 유무)
  • opening_day — date — 개업일
  • aos_id — varchar(30) — AOS 가입 아이디
  • rims_id — varchar(30) — RIMS 가입 아이디
  • id (id2) — int(11) — Foreign key → user.id — NOT NULL

rent_company_for_contract

  • id — int(11) — Foreign key → user.id — NOT NULL
  • realname — varchar(255) — NOT NULL
  • company — varchar(255) — NOT NULL
  • contact — varchar(255) — NOT NULL
  • custom_term — text
  • company_group_id — int(11) — Foreign key → rent_company_group.id
  • id (id2) — int(11) — Foreign key → user.id — NOT NULL

rent_company_group

  • id — int(11) — NOT NULL
  • created_at — timestamp — NOT NULL
  • is_enabled — tinyint(1) — NOT NULL
  • removed_at — timestamp
  • group_name — varchar(50) — NOT NULL
  • group_leader_id — int(11) — Foreign key → rent_company_user.id — NOT NULL
  • share_car_data — tinyint(1) — NOT NULL
  • id (id2) — int(11) — Foreign key → rent_company_user.id — NOT NULL

rent_company_partner

  • id — int(11) — NOT NULL
  • created_at — timestamp — NOT NULL
  • is_enabled — tinyint(1) — NOT NULL
  • removed_at — timestamp
  • partner_name — varchar(100) — NOT NULL
  • partner_contact — varchar(30)
  • partner_manager — varchar(30)
  • partner_address — varchar(255)
  • rent_company_id — int(11) — Foreign key → user.id — NOT NULL

rent_company_user

  • realname — varchar(255) — NOT NULL
  • nickname — varchar(255)
  • company — varchar(255) — NOT NULL
  • title — varchar(255) — NOT NULL
  • contact — varchar(255) — NOT NULL
  • id — int(11) — Foreign key → user.id — NOT NULL
  • car_count_domestic — int(11) — NOT NULL
  • car_count_imported — int(11) — NOT NULL
  • car_insurance_type — ENUM
  • 불가) — NOT — NOT NULL
  • description — text
  • _thumbnail — varchar(255)
  • location2_id — int(11) — Foreign key → location.id
  • location1_id — int(11) — Foreign key → location.id — NOT NULL
  • location3_id — int(11) — Foreign key → location.id
  • cash — int(20) — NOT NULL
  • point — int(20) — NOT NULL
  • registration_num — varchar(30)
  • custom_term — text
  • company_group_id — int(11) — Foreign key → rent_company_group.id
  • group_joined — tinyint(4) — NOT NULL
  • use_partner — tinyint(1)
  • use_form — tinyint(1) — NOT NULL
  • auto_up_free_coupon — int(5) — NOT NULL
  • remarks — varchar(70)
  • email — varchar(30)
  • response_restricted — tinyint(1) — NOT NULL
  • cash_warning_push — tinyint(1) — NOT NULL
  • restricted_to — datetime
  • restricted_from — datetime
  • address — varchar(100)
  • address_lat — decimal(10,8)
  • address_lng — decimal(11,8)
  • penalty_ocr_point — int(11)
  • penalty_ocr_bonus — int(11) — NOT NULL
  • field_service — tinyint(4) — NOT NULL
  • company_contact — varchar(20)
  • id (id2) — int(11) — Foreign key → user.id — NOT NULL

rent_employee_user

  • id — int(11) — NOT NULL
  • employer_id — int(11) — Foreign key → rent_company_user.id
  • realname — varchar(255) — NOT NULL
  • nickname — varchar(255)
  • company — varchar(255) — NOT NULL
  • title — varchar(255) — NOT NULL
  • contact — varchar(255) — NOT NULL
  • permission — int(2) — NOT NULL
  • claim_employee — tinyint(1)
  • contract_employer_id — int(11) — Foreign key → rent_company_for_contract.id
  • liaison — tinyint(1) — NOT NULL
  • drivers_license_id — int(10) — Foreign key → drivers_license.id
  • use_connect — tinyint(1)
  • admin — tinyint(1) — NOT NULL — 어드민 접속 직원 계정여부
  • access_limit — timestamp — 어드민 접속 허용 기한
  • id (id2) — int(11) — Foreign key → rent_company_user.id — NOT NULL

user

  • id — int(11) — Primary key — NOT NULL
  • user_type — varchar(255) — NOT NULL
  • username — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • enabled — tinyint(1) — NOT NULL
  • is_banned — tinyint(1) — NOT NULL
  • certificate_num — int(11)
  • certificate_time — datetime
  • created_at — datetime — NOT NULL
  • not_show_again — tinyint(1) — NOT NULL
  • belong_to — ENUM — NOT NULL
  • removed_at — timestamp
  • thumbnail — varchar(200)
  • admin_memo — varchar(100)
  • last_access_time — datetime
  • approval_time — datetime
  • failed_login_attempt — int(2) — NOT NULL
  • agreed_to_privacy_policy — tinyint(4) — NOT NULL
  • password_updated_at — datetime
  • is_withdrawn — tinyint(1) — 회원탈퇴 여부
  • withdrawal_reason — ENUM — 회원탈퇴 사유
  • withdrawal_reason_detail — varchar(500) — 회원탈퇴 사유 직접 입력 시
  • management_memo — varchar(200) — 운영 관리 메모