fit v2
Tables (50)
api_token
- id — serial — Primary key — NOT NULL
- login_id — varchar(30) — NOT NULL
- acc_token — varchar(400)
- ref_token — varchar(30)
- type_cd — bpchar(1)
- acc_token_expire_dt — timestamptz
- ref_token_expire_dt — timestamptz
- succ_yn — bool — NOT NULL
- err_code — int2
- err_message — varchar(100)
- acc_ip — varchar(50) — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
app_version_history
- id — bigserial — Primary key — NOT NULL
- app_ver — varchar(20) — NOT NULL
- upd_content — varchar(1000) — NOT NULL
- apply_platform_type_cd — bpchar(1) — NOT NULL
- force_apply_yn — bool — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
board_category
- id — serial — Primary key — NOT NULL
- center_id — int4
- l_type_cd — bpchar(1) — NOT NULL
- s_type_cd — bpchar(1) — NOT NULL
- namee — varchar(50) — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
board_manual_qa
- manual_qa_id — serial — Primary key — NOT NULL
- center_id — int4
- cate_id — int4
- file_group_id — int8
- title — varchar(100) — NOT NULL
- content — text — NOT NULL
- answer — text
- view_cnt — int4 — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
- top_fix_yn — bool — NOT NULL
board_popup
- id — serial — Primary key — NOT NULL
- cate_id — int4
- file_group_id — int8
- task_type_cd — bpchar(1) — NOT NULL
- show_type_cd — bpchar(1) — NOT NULL
- title — varchar(100) — NOT NULL
- content — text — NOT NULL
- show_period_yn — bool — NOT NULL
- show_start_dt — date
- show_end_dt — date
- view_cnt — int4 — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
- center_id — int4 — NOT NULL
board_popup_target
- board_popup_id — int8 — Primary key — NOT NULL
- center_id — int4 — Primary key — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
board_qna
- id — serial — Primary key — NOT NULL
- center_id — int4
- cate_id — int4
- task_type_cd — bpchar(1) — NOT NULL
- parent_id — int4
- file_group_id — int8
- show_type_cd — bpchar(1) — NOT NULL
- staff_id — int4 — NOT NULL
- staff_nm — varchar(30) — NOT NULL
- staff_tel_no — varchar(11)
- staff_email — varchar(30)
- title — varchar(100) — NOT NULL
- content — text — NOT NULL
- view_cnt — int4 — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
board_staff_show
- board_notice_id — int4 — Primary key — NOT NULL
- task_type_cd — bpchar(1) — Primary key — NOT NULL
- staff_id — int4 — Primary key — NOT NULL
- read_yn — bool — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center
- id — serial — Primary key — NOT NULL
- chain_id — int4
- center_nm — varchar(40) — NOT NULL
- chain_brand_nm — varchar(40)
- chain_spot_nm — varchar(40)
- cross_lesson_yn — bool — NOT NULL
- biz_no — varchar(12)
- logo_url — varchar(200)
- center_type_cd — bpchar(1) — NOT NULL
- center_parent_id — int4
- biz_type_cd — bpchar(1) — NOT NULL
- contact_user_nm — varchar(20)
- contact_user_tel — varchar(11)
- tel_no — varchar(11) — NOT NULL
- fax_no — varchar(11)
- email — varchar(30)
- addr — varchar(100)
- addr_detl — varchar(50)
- bill_pos_atnd_auto_yn — bool — NOT NULL
- bill_app_atnd_auto_yn — bool — NOT NULL
- bill_staff_off_auto_yn — bool — NOT NULL
- holl_off_yn — bool — NOT NULL
- homepage_url — varchar(50)
- access_yn — bool — NOT NULL
- sms_api_key — varchar(100)
- sms_usr_id — varchar(30)
- sms_cnt — int4
- lms_cnt — int4
- mms_cnt — int4
- erp_api_id — varchar(20)
- erp_api_key — varchar(100)
- erp_comp_no — varchar(20)
- memo — varchar(300)
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
- contact_user_email — varchar(30)
center_banner
- center_id — int4 — Primary key — NOT NULL
- admin_web_1_nm — varchar(30)
- admin_web_1_url — varchar(300)
- admin_web_1_link — varchar(300)
- admin_web_2_nm — varchar(30)
- admin_web_2_url — varchar(300)
- admin_web_2_link — varchar(300)
- admin_web_3_nm — varchar(30)
- admin_web_3_url — varchar(300)
- admin_web_3_link — varchar(300)
- admin_app_1_nm — varchar(30)
- admin_app_1_url — varchar(300)
- admin_app_1_link — varchar(300)
- admin_app_2_nm — varchar(30)
- admin_app_2_url — varchar(300)
- admin_app_2_link — varchar(300)
- admin_app_3_nm — varchar(30)
- admin_app_3_url — varchar(300)
- admin_app_3_link — varchar(300)
- cust_app_1_nm — varchar(30)
- cust_app_1_url — varchar(300)
- cust_app_1_link — varchar(300)
- cust_app_2_nm — varchar(30)
- cust_app_2_url — varchar(300)
- cust_app_2_link — varchar(300)
- cust_app_3_nm — varchar(30)
- cust_app_3_url — varchar(300)
- cust_app_3_link — varchar(300)
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_bill
- center_id — int4 — Primary key — NOT NULL
- center_bill_id — bigserial — Primary key — NOT NULL
- center_parent_bill_id — int8
- sale_type_cd — bpchar(1) — NOT NULL
- time_dt — date — NOT NULL
- time_tm — timetz — NOT NULL
- bill_price — int4 — NOT NULL
- bill_pay_type_cd — bpchar(1) — NOT NULL
- bill_pay_bank — varchar(2)
- bill_recp_type_cd — bpchar(1) — NOT NULL
- bill_reg_staff_id — int4 — NOT NULL
- center_contract_id — int8
- center_cust_id — int4
- center_nm — varchar(40) — NOT NULL
- prod_type_cd — bpchar(1) — NOT NULL
- prod_nm — varchar(50) — NOT NULL
- ticket_type_cd — varchar(1)
- total_prod_buy_price — int4 — NOT NULL
- total_prod_pay_price — int4 — NOT NULL
- mileage_use_amount — int4 — NOT NULL
- out_stand_yn — bool — NOT NULL
- out_stand_price — int4 — NOT NULL
- sale_staff_id — int4
- less_staff_id — int4
- ret_yn — bool — NOT NULL
- ret_staff_id — int4
- ret_type_cd — varchar(1)
- ret_exec_dt — timestamptz
- ret_pay_type_cd — bpchar(1)
- ret_price — int4
- exp_type_cd — varchar(1)
- exp_item — varchar(40)
- exp_price — int4
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
- exp_cnt — int4
center_board_faq
- center_id — int4 — Primary key — NOT NULL
- center_board_faq_id — serial — Primary key — NOT NULL
- cate_id — int4
- file_group_id — int8
- top_fix_yn — bool — NOT NULL
- title — varchar(100) — NOT NULL
- content — text — NOT NULL
- view_cnt — int4 — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_board_notice
- center_id — int4 — Primary key — NOT NULL
- center_board_notice_id — bigserial — Primary key — NOT NULL
- cate_id — int4
- file_group_id — int8
- show_type_cd — bpchar(1) — NOT NULL
- top_fix_yn — bool — NOT NULL
- title — varchar(100) — NOT NULL
- content — text — NOT NULL
- view_cnt — int4 — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_chain
- id — serial — Primary key — NOT NULL
- center_cnt — int2 — NOT NULL
- namee — varchar(40)
- logo_url — varchar(200)
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_consult
- center_id — int4 — Primary key — NOT NULL
- center_consult_id — serial — Primary key — NOT NULL
- cust_yn — bool — NOT NULL
- center_cust_id — int4
- cust_nm — varchar(20) — NOT NULL
- tel_no — varchar(11)
- center_staff_id — int4 — NOT NULL
- consult_dt — date — NOT NULL
- consult_type_id — int4 — NOT NULL
- consult_type_nm — varchar(50) — NOT NULL
- consult_path — bpchar(1) — NOT NULL
- info_path — bpchar(1) — NOT NULL
- memo — varchar(1000)
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_consult_type
- center_id — int4 — Primary key — NOT NULL
- center_consult_type_id — serial — Primary key — NOT NULL
- consult_type_nm — varchar(50) — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_contract
- center_id — int4 — Primary key — NOT NULL
- center_cust_id — int4 — Primary key — NOT NULL
- center_contract_id — bigserial — Primary key — NOT NULL
- contract_type_cd — bpchar(1) — NOT NULL
- prod_type_cd — bpchar(1) — NOT NULL
- total_prod_cnt — int2 — NOT NULL
- total_org_price — int4 — NOT NULL
- total_buy_price — int4 — NOT NULL
- total_debt_price — int4 — NOT NULL
- buy_dt — date — NOT NULL
- use_reg_dt — date
- reg_staff_id — int4 — NOT NULL
- mileage_use_price — int4 — NOT NULL
- total_add_mileage — int4 — NOT NULL
- etc_disc_price — int4 — NOT NULL
- ret_yn — bool — NOT NULL
- ret_type_cd — varchar(1)
- memo — varchar(1000)
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_contract_bill
- center_id — int4 — Primary key — NOT NULL
- center_cust_id — int4 — Primary key — NOT NULL
- center_contract_id — int8 — Primary key — NOT NULL
- bill_seq — int2 — Primary key — NOT NULL
- buy_dt — date — NOT NULL
- debt_yn — bool — NOT NULL
- bill_price — int4 — NOT NULL
- pay_type_cd — bpchar(1) — NOT NULL
- pay_card_type_cd — varchar(2)
- pay_bank_type_cd — varchar(2)
- recp_type_cd — bpchar(1) — NOT NULL
- recp_no — varchar(20)
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_contract_event_history
- center_id — int4 — Primary key — NOT NULL
- center_cust_id — int4 — Primary key — NOT NULL
- center_contract_id — int8 — Primary key — NOT NULL
- event_history_id — bigserial — Primary key — NOT NULL
- center_prod_id — int8
- event_type_cd — bpchar(2) — NOT NULL
- event_content — varchar(200) — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_contract_prod
- center_id — int4 — Primary key — NOT NULL
- center_cust_id — int4 — Primary key — NOT NULL
- center_contract_id — int8 — Primary key — NOT NULL
- center_prod_id — int8 — Primary key — NOT NULL
- center_prod_ver — int8 — Primary key — NOT NULL
- contract_prod_seq — int2 — Primary key — NOT NULL
- contract_prod_upd_seq — bigserial — Primary key — NOT NULL
- use_yn — bool — NOT NULL
- total_prod_cnt — int2 — NOT NULL
- prod_type_cd — bpchar(1) — NOT NULL
- prod_nm — varchar(50) — NOT NULL
- prod_org_price — int4 — NOT NULL
- prod_buy_price — int4 — NOT NULL
- sale_staff_id — int4
- sale_staff_contract_type_cd — varchar(1)
- less_staff_id — int4
- less_staff_contract_type_cd — varchar(1)
- less_cnt_type_cd — varchar(1)
- less_cnt — int2
- less_join_cnt — int2
- less_absn_cnt — int2
- org_exp_start_dt — date
- org_exp_end_dt — date
- exp_start_dt — date
- exp_end_dt — date
- exp_plus_start_dt — date
- exp_plus_end_dt — date
- exp_plus_type_cd — varchar(1)
- exp_plus_cnt — int2
- exp_plus_day — int2
- exp_plus_memo — varchar(500)
- exp_plus_staff_id — int4
- use_reg_dt — date
- turn_bill_price — int4
- locker_no — int2
- locker_ret_dt — date
- ret_yn — bool — NOT NULL
- ret_type_cd — varchar(1)
- ret_apply_dt — timestamptz
- ret_exec_dt — timestamptz
- ret_exp_end_dt — date
- ret_pay_type_cd — varchar(1)
- ret_pay_bank — varchar(30)
- ret_pay_own — varchar(30)
- ret_pay_acc — varchar(30)
- ret_price — int4
- ret_use_price — int4
- ret_use_cnt — int2
- ret_mileage_price — int4
- ret_memo — varchar(100)
- ret_staff_id — int4
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
- less_resver_staff_yn — bool — NOT NULL
- org_sale_staff_id — int4
- org_less_staff_id — int4
- locker_rent_month — int2
center_cust
- center_id — int4 — NOT NULL
- center_cust_id — serial — NOT NULL
- namee — varchar(20) — NOT NULL
- nick_name — varchar(20)
- status_cd — bpchar(1) — NOT NULL
- atnd_no — varchar(20) — NOT NULL
- par_telno_yn — bool — NOT NULL
- phone — varchar(11) — NOT NULL
- phone_os_type_cd — bpchar(1)
- push_dev_id — varchar(64)
- push_token — varchar(512)
- tax_tel_no — varchar(11)
- email — varchar(30) — NOT NULL
- passwd — varchar(100)
- birthday — bpchar(8) — NOT NULL
- sex — bpchar(1) — NOT NULL
- img_url — varchar(300)
- mileage — int4 — NOT NULL
- addr — varchar(100)
- addr_detl — varchar(50)
- mkt_agree_email — bool — NOT NULL
- mkt_agree_sms — bool — NOT NULL
- mkt_agree_push — bool — NOT NULL
- memo — varchar(1000)
- join_term_agree_id — int4 — NOT NULL
- sms_auth_no — varchar(10)
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
- join_usage_agree_id — int4 — NOT NULL
- phone_auth_yn — bool — NOT NULL
- email_auth_yn — bool — NOT NULL
- app_push_setting_yn — bool — NOT NULL
- app_install_ver — varchar(20)
- app_use_auth_yn — bool — NOT NULL
center_cust_deactive
- center_cust_deactive_no — serial — Primary key — NOT NULL
- center_id — int4 — NOT NULL
- center_cust_id — int4 — NOT NULL
- namee — varchar(20) — NOT NULL
- status_cd — bpchar(1) — NOT NULL
- atnd_no — varchar(20) — NOT NULL
- phone — varchar(11) — NOT NULL
- phone_os_type_cd — bpchar(1)
- email — varchar(30) — NOT NULL
- passwd — varchar(100)
- mileage — int4 — NOT NULL
- addr — varchar(100)
- addr_detl — varchar(50)
- memo — varchar(1000)
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- phone_auth_yn — bool — NOT NULL
- email_auth_yn — bool — NOT NULL
- app_use_auth_yn — bool — NOT NULL
center_cust_mileage
- center_id — int4 — Primary key — NOT NULL
- center_cust_id — int4 — Primary key — NOT NULL
- center_cust_mileage_id — bigserial — Primary key — NOT NULL
- center_contract_id — int8
- bill_seq — int2
- manual_yn — bool — NOT NULL
- mileage_dt — timestamptz — NOT NULL
- mileage_type_cd — bpchar(1) — NOT NULL
- mileage — int4 — NOT NULL
- exp_start_dt — date — NOT NULL
- exp_end_dt — date — NOT NULL
- exp_yn — bool — NOT NULL
- memo — varchar(100)
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_cust_team
- center_id — int4 — Primary key — NOT NULL
- center_cust_team_id — serial — Primary key — NOT NULL
- center_cust_team_nm — varchar(30) — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_cust_team_group
- center_id — int4 — Primary key — NOT NULL
- center_cust_team_id — int4 — Primary key — NOT NULL
- center_cust_id — int4 — Primary key — NOT NULL
- center_cust_team_nm — varchar(30) — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_erp_history
- center_id — int4 — Primary key — NOT NULL
- erp_cate_type_cd — bpchar(1) — Primary key — NOT NULL
- erp_act_type_cd — bpchar(1) — Primary key — NOT NULL
- erp_history_id — bigserial — Primary key — NOT NULL
- bank_cd — varchar(30)
- bank_acc — varchar(30)
- bank_own — varchar(30)
- bank_alias — varchar(30)
- recp_comp — varchar(50)
- recp_biz_no — varchar(10)
- recp_maj_type — varchar(100)
- recp_min_type — varchar(100)
- recp_email — varchar(30)
- recp_reg_dt — date
- recp_price — int4
- recp_vat_price — int4
- recp_total_price — int4
- recp_usage — varchar(100)
- recp_content — varchar(100)
- recp_memo — varchar(100)
- card_comp — varchar(30)
- card_no — varchar(30)
- card_conf_price — int4
- card_usage — varchar(100)
- card_content — varchar(100)
- lone_conf_price — int4
- lone_sug_price — int4
- lone_vat_price — int4
- lone_svc_price — int4
- lone_usage — varchar(100)
- lone_content — varchar(100)
- lone_memo — varchar(100)
- etc_type_cd — varchar(1)
- etc_pay_yn — bool
- etc_pay_price — int4
- etc_vat_yn — bool
- etc_vat_price — int4
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_exp_item
- center_id — int4 — Primary key — NOT NULL
- center_bill_id — int8 — Primary key — NOT NULL
- history_id — bigserial — Primary key — NOT NULL
- exp_type_cd — bpchar(1) — NOT NULL
- exp_item — varchar(40) — NOT NULL
- exp_price — int4 — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_exp_item_tmpl
- center_id — int4 — Primary key — NOT NULL
- template_id — serial — Primary key — NOT NULL
- exp_type_cd — bpchar(1) — NOT NULL
- exp_item — varchar(40) — NOT NULL
- exp_price — int4 — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_holiday_cal
- center_holiday_cal_id — bigserial — NOT NULL
- center_id — int4 — NOT NULL
- holl_dt — date — NOT NULL
- holl_type_cd — bpchar(1) — NOT NULL
- content — varchar(100) — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_less_prod_category
- center_id — int4 — Primary key — NOT NULL
- center_less_schd_master_id — int8 — Primary key — NOT NULL
- center_prod_cate_tmpl_id — int8 — Primary key — NOT NULL
- center_prod_cate_tmpl_nm — varchar(30) — NOT NULL
- center_prod_cate_seq — int2 — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_less_schd
- center_id — int4 — Primary key — NOT NULL
- center_less_schd_master_id — int8 — Primary key — NOT NULL
- center_less_schd_id — bigserial — Primary key — NOT NULL
- less_dt — date — NOT NULL
- less_type_cd — bpchar(1) — NOT NULL
- less_nm — varchar(50) — NOT NULL
- less_staff_id — int4 — NOT NULL
- less_org_staff_id — int4 — NOT NULL
- center_schd_type_cd — varchar(50)
- center_staff_atnd_yn — bool — NOT NULL
- day_of_week — varchar(5) — NOT NULL
- less_total_tm — int2 — NOT NULL
- less_start_tm — timetz — NOT NULL
- less_end_tm — timetz — NOT NULL
- less_mem_max_cnt — int2 — NOT NULL
- less_mem_resv_cnt — int2 — NOT NULL
- less_mem_join_cnt — int2 — NOT NULL
- less_mem_wait_cnt — int2 — NOT NULL
- less_mem_abs_cnt — int2 — NOT NULL
- less_forc_off_yn — bool — NOT NULL
- less_forc_off_cond_time — int2
- less_forc_off_mem_cnt — int2
- less_off_yn — bool — NOT NULL
- less_off_resn — varchar(100)
- less_memo — varchar(100)
- center_staff_bill_status — bpchar(1) — NOT NULL
- center_staff_bill_dt — timestamptz
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
- less_mem_wait_enable_cnt — int2 — NOT NULL
- schd_type_cd — bpchar(1) — NOT NULL
- last_event_status_cd — bpchar(2) — NOT NULL
- room_pick_yn — bool — NOT NULL
center_less_schd_cust
- center_id — int4 — Primary key — NOT NULL
- center_less_schd_id — int8 — Primary key — NOT NULL
- center_cust_id — int4 — Primary key — NOT NULL
- join_seq — bigserial — NOT NULL
- center_contract_id — int8 — NOT NULL
- center_prod_id — int8 — NOT NULL
- center_cust_nm — varchar(20) — NOT NULL
- atnd_status_cd — bpchar(1) — NOT NULL
- atnd_dev_cd — bpchar(2) — NOT NULL
- atnd_exec_tm — timestamptz
- atnd_staff_id — int4
- resv_status_cd — bpchar(2) — NOT NULL
- resv_wait_seq — int2
- resvr_type_cd — bpchar(1) — NOT NULL
- resvr_id — int4 — NOT NULL
- schd_cancel_rsn — varchar(50)
- less_cust_off_rsn — varchar(50)
- bill_status_cd — bpchar(1) — NOT NULL
- bill_exec_tm — timestamptz
- bill_staff_id — int4
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
- resv_dev_cd — bpchar(2)
- contract_seq — int2
center_less_schd_event_history
- center_id — int4 — Primary key — NOT NULL
- center_less_schd_master_id — int8 — Primary key — NOT NULL
- event_id — bigserial — Primary key — NOT NULL
- event_type_cd — varchar(2) — NOT NULL
- event_content — varchar(300) — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_less_schd_master
- center_id — int4 — Primary key — NOT NULL
- center_less_schd_master_id — bigserial — Primary key — NOT NULL
- schd_type_cd — bpchar(1) — NOT NULL
- schd_rep_type_cd — bpchar(1) — NOT NULL
- schd_rep_week — bpchar(13) — NOT NULL
- less_staff_id — int4 — NOT NULL
- less_org_staff_id — int4 — NOT NULL
- center_schd_type_cd — varchar(50)
- less_type_cd — bpchar(1) — NOT NULL
- less_nm — varchar(50) — NOT NULL
- less_total_tm — int2 — NOT NULL
- less_start_dt — date — NOT NULL
- less_start_tm — timetz — NOT NULL
- less_end_dt — date — NOT NULL
- less_end_tm — timetz — NOT NULL
- less_mem_max_cnt — int2
- less_forc_off_yn — bool — NOT NULL
- less_forc_off_cond_time — int2
- less_forc_off_mem_cnt — int2
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
- less_mem_wait_enable_cnt — int2 — NOT NULL
- last_event_status_cd — bpchar(2) — NOT NULL
center_locker
- center_id — int4 — NOT NULL
- center_prod_id — int8 — NOT NULL
- locker_no — int2 — NOT NULL
- locker_status — bpchar(1) — NOT NULL
- use_yn — bool — NOT NULL
- sex — bpchar(1) — NOT NULL
- rent_cust_id — int4
- rent_cust_nm — varchar(20)
- rent_month — int2
- rent_start_dt — date
- rent_end_dt — date
- rent_return_dt — date
- rent_bill_dt — date
- rent_bill_id — int8
- rent_bill_price — int4
- locker_group_nm — varchar(30) — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
- center_contract_id — int8
center_locker_history
- center_locker_history_id — bigserial — NOT NULL
- center_id — int4 — NOT NULL
- center_prod_id — int8 — NOT NULL
- locker_no — int2 — NOT NULL
- rent_cust_id — int4
- rent_cust_nm — varchar(20)
- rent_start_dt — date
- rent_end_dt — date
- rent_return_dt — date
- center_contract_id — int8
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_menu
- id — serial — Primary key — NOT NULL
- pid — int4
- menu_cd — varchar(30) — NOT NULL
- menu_nm — varchar(30) — NOT NULL
- tree_level — int2 — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_menu_event
- menu_id — int4 — Primary key — NOT NULL
- menu_event_cd — varchar(30) — Primary key — NOT NULL
- menu_cd — varchar(30) — NOT NULL
- menu_nm — varchar(30) — NOT NULL
- menu_event_nm — varchar(30) — NOT NULL
- menu_event_desc — varchar(100)
- event_type_cd — bpchar(1) — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_menu_event_custom
- center_id — int4 — Primary key — NOT NULL
- role_id — int4 — Primary key — NOT NULL
- menu_id — int4 — Primary key — NOT NULL
- menu_event_cd — varchar(30) — Primary key — NOT NULL
- use_yn — bool — NOT NULL
- menu_cd — varchar(30) — NOT NULL
- menu_nm — varchar(30) — NOT NULL
- menu_event_nm — varchar(30) — NOT NULL
- menu_event_desc — varchar(100)
- event_type_cd — bpchar(1) — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_mileage_setting
- center_id — int4 — Primary key — NOT NULL
- tick_card_yn — bool — NOT NULL
- tick_card_ratio — numeric(5,2)
- tick_cash_yn — bool — NOT NULL
- tick_cash_ratio — numeric(5,2)
- tick_bank_yn — bool — NOT NULL
- tick_bank_ratio — numeric(5,2)
- tick_etc_yn — bool — NOT NULL
- tick_etc_ratio — numeric(5,2)
- atnd_accm_use_yn — bool — NOT NULL
- atnd_accm_milige — int2
- accm_keep_yn — bool — NOT NULL
- accm_keep_day — int2
- milige_use_lock_yn — bool — NOT NULL
- milige_use_price — int4
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_mileage_setting_history
- center_id — int4 — Primary key — NOT NULL
- setting_history_id — serial — Primary key — NOT NULL
- tick_card_yn — bool — NOT NULL
- tick_card_ratio — numeric(5,2)
- tick_cash_yn — bool — NOT NULL
- tick_cash_ratio — numeric(5,2)
- tick_bank_yn — bool — NOT NULL
- tick_bank_ratio — numeric(5,2)
- tick_etc_yn — bool — NOT NULL
- tick_etc_ratio — numeric(5,2)
- atnd_accm_use_yn — bool — NOT NULL
- atnd_accm_milige — int2
- accm_keep_yn — bool — NOT NULL
- accm_keep_day — int2
- milige_use_lock_yn — bool — NOT NULL
- milige_use_price — int4
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_nation_holiday_setting
- center_id — int4 — Primary key — NOT NULL
- year — int2 — Primary key — NOT NULL
- holl_check_yn — bool — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_prod
- center_id — int4 — Primary key — NOT NULL
- center_prod_id — bigserial — Primary key — NOT NULL
- center_prod_ver — bigserial — Primary key — NOT NULL
- use_yn — bool — NOT NULL
- prod_type_cd — bpchar(1) — NOT NULL
- namee — varchar(50) — NOT NULL
- prod_comment — varchar(500) — archar(500) NUL
- ticket_type_cd — varchar(1)
- period_type_cd — varchar(1)
- period_cnt — int2
- less_cnt_type_cd — varchar(1)
- less_cnt — int2
- less_time — int2
- less_member_cnt — int2
- less_cross_yn — bool
- less_staff_id — int4
- resv_app_yn — bool
- resv_limit_type_cd — varchar(1)
- resv_limit_cnt — int2
- resv_day_dup_yn — bool
- resv_cancel_type_cd — varchar(1)
- resv_cancel_cnt — int2
- turn_bill_price — int4
- recv_price — int4 — NOT NULL
- sell_price — int4 — NOT NULL
- vat_yn — bool — NOT NULL
- stoc_type_cd — bpchar(1) — NOT NULL
- stoc_use_yn — bool — NOT NULL
- stoc_total_cnt — int4
- stoc_manual_yn — bool — NOT NULL
- lock_no_range_start — int2
- lock_no_range_end — int2
- lock_sex — varchar(1)
- lock_fix_price_yn — bool
- lock_fix_price — int4
- lock_mon1_price — int4
- lock_mon2_price — int4
- lock_mon3_price — int4
- lock_mon4_price — int4
- lock_mon5_price — int4
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
- less_per_less_cnt — numeric(2,1)
- lock_mon1_month — int2
- lock_mon2_month — int2
- lock_mon3_month — int2
- lock_mon4_month — int2
- lock_mon5_month — int2
- once_type — varchar(1)
center_prod_category
- center_id — int4 — Primary key — NOT NULL
- center_prod_id — int8 — Primary key — NOT NULL
- center_prod_cate_tmpl_id — bigserial — Primary key — NOT NULL
- namee — varchar(30) — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_prod_category_tmpl
- center_id — int4 — Primary key — NOT NULL
- center_prod_cate_tmpl_id — bigserial — Primary key — NOT NULL
- namee — varchar(30) — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_prod_pack_detl
- center_id — int4 — Primary key — NOT NULL
- center_parent_prod_id — int8 — Primary key — NOT NULL
- center_child_prod_id — int8 — Primary key — NOT NULL
- disp_seq — int2 — Primary key — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_resv_setting
- center_id — int4 — Primary key — NOT NULL
- w1_yn — bool — NOT NULL
- w1_start_tm — timetz
- w1_end_tm — timetz
- w2_yn — bool — NOT NULL
- w2_start_tm — timetz
- w2_end_tm — timetz
- w3_yn — bool — NOT NULL
- w3_start_tm — timetz
- w3_end_tm — timetz
- w4_yn — bool — NOT NULL
- w4_start_tm — timetz
- w4_end_tm — timetz
- w5_yn — bool — NOT NULL
- w5_start_tm — timetz
- w5_end_tm — timetz
- w6_yn — bool — NOT NULL
- w6_start_tm — timetz
- w6_end_tm — timetz
- w7_yn — bool — NOT NULL
- w7_start_tm — timetz
- w7_end_tm — timetz
- tm_unit_val — int2 — NOT NULL
- tm_disp_app_30 — int2
- tm_disp_app_60 — int2
- tm_disp_app_90 — int2
- tm_disp_app_120 — int2
- c_resv_ot — bpchar(8) — NOT NULL
- c_resv_gr — bpchar(8) — NOT NULL
- c_resv_cp — bpchar(8) — NOT NULL
- c_cancel_ot — bpchar(8) — NOT NULL
- c_cancel_gr — bpchar(8) — NOT NULL
- c_cancel_cp — bpchar(8) — NOT NULL
- c_pre_ot — int2 — NOT NULL
- c_pre_gr — int2 — NOT NULL
- c_pre_cp — int2 — NOT NULL
- t_resv_ot — bpchar(8) — NOT NULL
- t_resv_du — bpchar(8) — NOT NULL
- t_resv_gr — bpchar(8) — NOT NULL
- t_resv_cp — bpchar(8) — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_room
- center_id — int4 — Primary key — NOT NULL
- center_room_id — serial — Primary key — NOT NULL
- namee — varchar(30) — NOT NULL
- use_yn — bool — NOT NULL
- resv_yn — bool — NOT NULL
- limit_yn — bool — NOT NULL
- limit_cnt — int2 — NOT NULL
- memo — varchar(100)
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_sale_stats
- center_id — int4 — Primary key — NOT NULL
- sale_year_month — bpchar(6) — Primary key — NOT NULL
- tick_price — int4 — NOT NULL
- tick_cnt — int4 — NOT NULL
- prod_price — int4 — NOT NULL
- prod_cnt — int4 — NOT NULL
- ret_price — int4 — NOT NULL
- ret_cnt — int4 — NOT NULL
- total_sale_price — int4 — NOT NULL
- total_sale_cnt — int4 — NOT NULL
- fix_exp_price — int4 — NOT NULL
- fix_exp_cnt — int4 — NOT NULL
- var_exp_price — int4 — NOT NULL
- var_exp_cnt — int4 — NOT NULL
- pay_price — int4 — NOT NULL
- pay_cnt — int4 — NOT NULL
- total_exp_price — int4 — NOT NULL
- total_exp_cnt — int4 — NOT NULL
- oper_profit_price — int4 — NOT NULL
- oper_profit_cnt — int4 — NOT NULL
- tick_exh_price — int4 — NOT NULL
- tick_exh_cnt — int4 — NOT NULL
- tick_remain_price — int4 — NOT NULL
- tick_remain_cnt — int4 — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
center_schd_room
- center_id — int4 — Primary key — NOT NULL
- center_less_schd_id — int8 — Primary key — NOT NULL
- use_seq — bigserial — Primary key — NOT NULL
- center_room_id — int4 — Primary key — NOT NULL
- use_start_tm — timetz — NOT NULL
- use_end_tm — timetz — NOT NULL
- cre_dt — timestamptz — NOT NULL
- cre_nm — varchar(30) — NOT NULL
- upd_dt — timestamptz — NOT NULL
- upd_nm — varchar(30) — NOT NULL
- del_yn — bool — NOT NULL
- use_dt — date — NOT NULL