원파트너스

테이블 (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