원파트너스
테이블 (15)
tbl_auth
- auth_idx — int(11) — 기본 키 — NOT NULL
- auth_phone — varchar(20) — NOT NULL
- auth_sms_id — varchar(50)
- auth_num — varchar(10) — NOT NULL
- expired_start_at — datetime — NOT NULL
- expired_end_at — datetime — NOT NULL
tbl_banner
- banner_idx — int(11) — 기본 키 — NOT NULL
- banner_title — varchar(100)
- banner_img_pc — varchar(255)
- banner_img_mo — varchar(255)
- banner_link — varchar(255)
- banner_order — int(11)
- banner_is_view — enum('Y','N')
- banner_created_at — datetime
- banner_updated_at — datetime
- banner_deleted_at — datetime
tbl_blocked_ip
- blocked_ip_idx — int(11) — 기본 키 — NOT NULL
- blocked_ip — varchar(45) — NOT NULL
- blocked_reason — varchar(255)
- blocked_created_at — datetime
tbl_board
- board_idx — int(11) — 기본 키 — NOT NULL
- board_title — varchar(200) — NOT NULL
- board_content — longtext
- board_img — varchar(255)
- board_view_cnt — int(11)
- board_created_at — datetime
- board_updated_at? — datetime
- board_deleted_at — datetime
tbl_brand
- brand_idx — int(11) — 기본 키 — NOT NULL
- brand_type — enum('국산','수입')
- brand_name — varchar(50) — NOT NULL
- brand_img — varchar(255)
- brand_order — int(11)
- brand_created_at — datetime
- brand_updated_at — datetime
- brand_deleted_at — datetime
- brand_is_main — varchar(45) — NOT NULL
tbl_config
- config_idx — int(11) — 기본 키 — NOT NULL
- config_site_name — varchar(100)
- config_last_assign_idx — int(11)
- config_dist_count — int(11) — 글로벌 DB 분배 수량
- config_created_at — datetime
- config_updated_at — datetime
- config_meta_script — text
- config_comp_name — varchar(100)
- config_comp_num — varchar(50)
- config_comp_mail_num — varchar(50)
- config_comp_addr — varchar(255)
- config_comp_tel — varchar(20)
- config_comp_email — varchar(100)
- config_sms_use — enum('Y', 'N')
- config_grade_option_show — enum('Y', 'N')
- config_nhn_sms_app_key — varchar(100) — NHN Cloud SMS 앱키
- config_nhn_sms_send_no — varchar(45) — NHN SMS 발신번호
- config_immediate_banner_pc — varchar(255)
- config_immediate_banner_mo — varchar(255)
tbl_consult
- consult_idx — int(11) — 기본 키 — NOT NULL
- consult_name — varchar(50) — NOT NULL
- consult_tel — varchar(20) — NOT NULL
- consult_is_verified — enum('Y', 'N')
- consult_car_model — varchar(100)
- consult_car_trim — varchar(100)
- consult_car_color — varchar(50)
- consult_car_option — text
- consult_use_type — varchar(20) — 렌트/리스
- consult_use_period — varchar(20)
- consult_init_cost — varchar(50)
- consult_mileage — varchar(50)
- consult_memo — text
- consult_status — varchar(20)
- agent_idx — int(11)
- consult_inflow — varchar(100)
- consult_keyword — varchar(100)
- consult_ip — varchar(50)
- consult_created_at — datetime
- consult_updated_at — datetime
- consult_deleted_at — datetime
tbl_consult_memo
- memo_idx — int(11) — 기본 키 — NOT NULL
- consult_idx — int(11) — NOT NULL
- memo_content — text — NOT NULL
- author_type — varchar(20) — NOT NULL — admin|agent
- author_idx — int(11) — NOT NULL
- author_name — varchar(100) — NOT NULL
- created_at — datetime — NOT NULL
tbl_ip_request_log
- request_log_idx — int(11) — 기본 키 — NOT NULL
- request_ip — varchar(45) — NOT NULL
- request_path — varchar(255) — NOT NULL
- requested_at — datetime — NOT NULL
tbl_promotion
- promotion_idx — int(11) — 기본 키 — NOT NULL
- promotion_title — varchar(200) — NOT NULL
- promotion_sub_title — varchar(200)
- promotion_start_date — date
- promotion_end_date — date
- promotion_thumb — varchar(255)
- promotion_detail_img — varchar(255)
- promotion_view_cnt — int(11)
- promotion_is_visible — enum('Y','N')
- promotion_is_fixed — enum('Y','N')
- promotion_created_at — datetime
- promotion_updated_at — datetime
- promotion_deleted_at — datetime
tbl_review
- review_idx — int(11) — 기본 키 — NOT NULL
- review_car_name — varchar(100)
- review_title — varchar(200)
- review_star — tinyint(4)
- review_content — text
- review_author — varchar(50)
- review_img — varchar(255)
- review_is_fixed — enum('Y','N')
- review_created_at — datetime
- review_updated_at — datetime
- review_deleted_at — datetime
tbl_terms
- terms_idx — int(11) — 기본 키 — NOT NULL
- terms_code — varchar(20) — NOT NULL
- terms_title — varchar(100)
- terms_content — longtext
- terms_created_at — datetime
- terms_updated_at — datetime
- terms_deleted_at — datetime
tbl_vehicle
- vehicle_idx — int(11) — 기본 키 — NOT NULL
- brand_idx — int(11) — NOT NULL
- vehicle_brand — varchar(50)
- vehicle_model — varchar(100)
- vehicle_trim — varchar(100)
- vehicle_img — varchar(255)
- vehicle_grades — text
- vehicle_colors — text
- vehicle_sort — int(11)
- vehicle_created_at — datetime
- vehicle_updated_at — datetime
- vehicle_deleted_at — datetime
- vehicle_type — varchar(50)
- vehicle_year — varchar(20)
- vehicle_price — bigint(20)
- vehicle_monthly_pay — int(11)
관리자 계정
- admin_idx — int(11) — 기본 키 — NOT NULL
- admin_id — varchar(50) — NOT NULL
- admin_pw — varchar(255) — NOT NULL
- admin_name — varchar(50) — NOT NULL
- admin_is_super — tinyint(1) — NOT NULL
- admin_created_at — datetime
- admin_updated_at — datetime
- admin_deleted_at — datetime
영업사원 계정 (tbl_agent)
- agent_idx — int(11) — 기본 키 — NOT NULL
- agent_id — varchar(50) — NOT NULL
- agent_pw — varchar(255) — NOT NULL
- agent_name — varchar(50) — NOT NULL
- agent_tel — varchar(20)
- agent_email — varchar(100)
- agent_status — enum('ON', 'OFF')
- agent_is_dist — enum('Y', 'N') — DB분배 참여여부
- agent_dist_order — int(11) — 분배순서
- agent_dist_count — int(11) — 회당 분배수량
- agent_dist_current — int(11) — 현재 사이클 분배수량
- agent_assignment_order — int(11)
- agent_created_at — datetime
- agent_updated_at — datetime
- agent_deleted_at — datetime