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) — 운영 관리 메모