AfterSpace
Tables (88)
tb_aft_credit
- pre_id — varchar(128) — Primary key — NOT NULL — premium id
- qty — int — NOT NULL — remain credit qty
- last_charged_dt — datetime — NOT NULL — last charged date
- reg_dt — datetime — NOT NULL — when added
tb_aft_credit_charge
- chr_hist — int — Primary key — NOT NULL — payment hist
- seq — int — Foreign key → tb_aft_credit_hist.seq — NOT NULL — seqeunce of history
- pre_id — varchar(128) — Foreign key → tb_aft_credit_hist.pre_id — NOT NULL — premium id
- amt — int — NOT NULL — charged price
- result_cd — varchar(30) — NOT NULL — result code
- result_msg — varchar(512) — NOT NULL — result message
- reg_dt — datetime — NOT NULL — when added
tb_aft_credit_hist
- seq — int — Primary key — NOT NULL — seqeunce of history
- pre_id — varchar(128) — Foreign key → tb_aft_credit.pre_id — NOT NULL — premium id
- point — int — NOT NULL — point charged of used
- reason — varchar(256) — NOT NULL — reason
- pay_seq — int — NOT NULL — payment sequence
- reg_dt — datetime — NOT NULL — when added
- reg_id — varchar(128) — NOT NULL — who added
tb_api_key
- api_key — varchar(256) — Primary key — NOT NULL
- api_pwd — varchar(512) — NOT NULL
- req_nm — varchar(40) — NOT NULL
- req_email — varchar(128) — NOT NULL
- req_message — text — NOT NULL
- req_tel — varchar(15) — NOT NULL
- confirm_yn — varchar(1) — NOT NULL
- refuse_yn — varchar(1) — NOT NULL
- reg_dt — datetime — NOT NULL
- mod_dt — datetime — NOT NULL
- mod_id — varchar(128) — NOT NULL
- acc_host — varchar(256)
tb_api_log
- seq — int — Primary key — NOT NULL
- api_key — varchar(256) — Foreign key → tb_api_key.api_key — NOT NULL
- url — varchar(128) — NOT NULL
- acc_time — datetime — NOT NULL
tb_area_code
- root_key — int — NOT NULL
- sub_key — int
- name — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_banner
- locate_cd — varchar(30) — NOT NULL
- img_path — varchar(256) — NOT NULL
- use_yn — varchar(1)
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_book_proc
- book_seq — int — Foreign key → tb_space_book.book_seq — NOT NULL
- step01_yn — varchar(1)
- step02_yn — varchar(1)
- step03_yn — varchar(1)
- step03_d01_yn — varchar(1)
- step03_d02_yn — varchar(1)
- step03_d03_yn — varchar(1)
- step03_d04_yn — varchar(1)
- step03_d05_yn — varchar(1)
- step04_yn — varchar(1)
- step04_d01_yn — varchar(1)
- step04_d02_yn — varchar(1)
- step05_yn — varchar(1)
- step05_d01_yn — varchar(1)
- mod_dt — DATETIME
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime
tb_brand_caller
- pre_id — varchar(128) — Primary key — NOT NULL — premium id
- caller_id — varchar(15) — Primary key — NOT NULL — calling number
- status_cd — varchar(30) — NOT NULL — status code(01 : 요청, 02:등록완료,10:거부))
- reason — varchar(512) — 거절 사유
- file1 — varchar(256) — attachment file 1
- file2 — varchar(256) — attachment file 2
- file3 — varchar(256) — attachment file 3
- reg_dt — datetime — NOT NULL — when added
- mod_dt — datetime — NOT NULL — when modified
tb_brand_customer
- pre_id — varchar(128) — Primary key — NOT NULL — premium id
- seq — int — Primary key — NOT NULL — sequence
- cust_type — varchar(20) — cust_type
- tel — varchar(15) — NOT NULL — customer tel
- agree_term — varchar(1) — NOT NULL — agree with term
- cust_nm — varchar(30) — customer name
- cust_email — varchar(128) — customer email
- ref — varchar(256) — customer funneling
- reg_dt — datetime — NOT NULL — when added
tb_brand_delivery_info
- user_id — varchar(128) — Foreign key — NOT NULL
- deli_cd — varchar(30) — NOT NULL
- ship_type — varchar(30) — NOT NULL
- price — int
- out_addr — varchar(128)
- out_addr2 — varchar(128)
- out_zipcode — varchar(6)
- rtn_addr — varchar(128)
- rtn_addr2 — varchar(128)
- rtn_zipcode — varchar(6)
- reg_dt — datetime — NOT NULL
- reg_id — varchar(128) — NOT NULL
- mod_dt — datetime — NOT NULL
- mod_id — varchar(128) — NOT NULL
tb_brand_nicepay
- user_id — varchar(128) — Primary key — NOT NULL — user id
- pre_id — varchar(128) — NOT NULL — premium id
- cat_id — varchar(10) — cat id for van code
- pg_mid — varchar(30) — mid for pg
- pg_key — varchar(256) — key for pg
- pg_cancel_pwd — varchar(128) — cancel pwd for pg
- reg_dt — datetime — NOT NULL — when added
- mod_dt — datetime — NOT NULL — when modified
- reg_id — varchar(128) — NOT NULL — who added
- mod_id — varchar(128) — NOT NULL — who modified
- status_cd — varchar(30) — status code
tb_brand_payment_hist
- user_id — varchar(128) — Primary key — NOT NULL — user id
- pay_key — varchar(256) — Primary key — NOT NULL — payment key(bill key)
- seq — int — Primary key — NOT NULL — sequence of hist
- req_no — varchar(10) — Foreign key → tb_module_request.req_no — NOT NULL — request no(yymmdd+0000)
- sub_no — varchar(10) — Foreign key → tb_module_subscribe.sub_no — NOT NULL — subscribe no(yymmdd+0000)
- paid_amt — int — NOT NULL — paid amt
- tid — varchar(128) — NOT NULL — tid
- result_cd — varchar(30) — result code
- result_msg — varchar(128) — result msg
- paid_dt — varchar(20) — paid date
- reg_dt — datetime — NOT NULL — when added
tb_brand_payments
- seq — int — Primary key — NOT NULL — sequence of payments
- user_id — varchar(128) — Foreign key — NOT NULL
- pay_key — varchar(256) — NOT NULL — payment key(billing key)
- pay_nm — varchar(64) — NOT NULL — payment name
- pay_id — varchar(128) — NOT NULL — pay id(moid etc)
- goods_nm — varchar(128) — NOT NULL — goods name
- card_cd — varchar(30) — card code
- card_nm — varchar(64) — card name
- card_no — varchar(32) — card no
- back_cd — varchar(30) — bank cd
- back_nm (bank_nm) — varchar(64) — bank name
- bank_account — varchar(64) — bank account
- use_yn — varchar(1) — NOT NULL — use yn
- reg_dt — datetime — NOT NULL — when added
- del_dt — datetime — when deleted
tb_cafe24_info
- user_id — varchar(128) — Primary key — NOT NULL
- mall_id — varchar(64) — Primary key — NOT NULL
- cafe24_user_id — varchar(64) — NOT NULL
- client_id — varchar(256)
- secret — varchar(256)
- reg_dt — datetime — NOT NULL
- pre_id — varchar(128)
tb_cafe24_token
- mall_id — varchar(64) — Foreign key → tb_cafe24_info.mall_id — NOT NULL
- acct_token — varchar(256) — NOT NULL — access token
- acct_exp_dt — date — NOT NULL — access token expired time
- refresh_token — varchar(256) — NOT NULL — refresh_token
- refresh_exp_dt — date — NOT NULL — refresh token expired time
- reg_dt — datetime — NOT NULL — when added
- mod_dt — datetime — NOT NULL — when modified
tb_chat
- chat_seq — int — Primary key — NOT NULL
- book_seq — int — Foreign key → tb_space_book.book_seq — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_chat_hist
- hist_seq — int — Primary key — NOT NULL
- chat_seq — int — Foreign key → tb_chat.chat_seq — NOT NULL
- msg — varchar(512) — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_code
- code_seq — int — Primary key — NOT NULL
- code — varchar(30) — NOT NULL
- value — varchar(128) — NOT NULL
- name — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_contract_file
- book_seq — int — Primary key — NOT NULL — 예약일련번호
- hist_seq — int — Primary key — NOT NULL — 일련번호
- file_snm — varchar(256) — NOT NULL — 파일 저장명
- file_rnm — varchar(256) — NOT NULL — 파일 실제명
- file_type — varchar(30) — NOT NULL — 파일유형
- file_path — varchar(512) — NOT NULL — 파일 경로
- file_ext — varchar(30) — 확장자
- reg_id — varchar(128) — NOT NULL — 등록 아이디
- reg_dt — datetime — NOT NULL — 등록 일자
tb_daily_cls
- pre_id — varchar(128) — Primary key — NOT NULL — premium id
- space_seq — int — Primary key — NOT NULL — store sequence
- clo_dt — varchar(8) — Primary key — NOT NULL — closing date
- clo_yn — varchar(1) — NOT NULL — 마감여부
- start_at — datetime — 시작시간
- end_at — datetime — 종료시작
- start_cash_yn — varchar(1) — 준비금여부
- start_cash — int — 준비금액
- end_cash — int — 종료금액
- start_cash_paper — varchar(50) — 시작시 권종별 수량
- end_cash_paper — varchar(50) — 마감시 권종수량
- sales_amt — number — 매출
- card_amt — number — 카드매출
- cash_amt — number — 현금매출
- etc_amt — number — 기타결제
- simple_amt — number — 간편결제
- pickup_amt — number — 현장수령 금액
- delivery_amt — number — 온라인배송 금액
- refund_amt — number — 환불금액
- discount_amt — number — 총 할인금액
- cp_cnt — int — 쿠폰 사용횟수
- use_point_amt — int — 사용한 적립금
- acc_point_amt — int — 적립한 금액
- reg_dt — datetime — NOT NULL — 최초등록일
- reg_id — varchar(128) — NOT NULL — 최초 등록자
- mod_dt — datetime — NOT NULL — 수정일
- mod_id — varchar(128) — NOT NULL — 수정자
tb_daily_cls_log
- log_dt — datetime — Primary key — NOT NULL — 로그일자
- pre_id — varchar(128) — Foreign key → tb_daily_cls.pre_id — NOT NULL — premium id
- space_seq — int — Foreign key → tb_daily_cls.space_seq — NOT NULL — store sequence
- clo_dt — varchar(8) — Foreign key → tb_daily_cls.clo_dt — NOT NULL — closing date
- type — varchar(1) — NOT NULL — (A:준비금, I:입금,O:출금, S:시작,E:종료,P:시재)
- amt — int — 금액
- reg_id — varchar(128) — NOT NULL — 등록자
- reg_dt — datetime — NOT NULL — 등록일
- etc — varchar(512) — 기타 메시지
tb_err_report
- seq — int — NOT NULL — 일련번호
- title — varchar(512) — NOT NULL — 제목
- context — text — NOT NULL — 내용
- answer — text — 답변
- link — varchar(256) — 에러 링크
- status_cd — varchar(30) — NOT NULL — 진행상황
- reg_id — varchar(128) — NOT NULL — 등록아이디
- reg_dt — datetime — NOT NULL — 등록일자
tb_event
- event_seq — int — Primary key — NOT NULL
- event_nm — varchar(128) — NOT NULL
- use_yn — varchar(1) — NOT NULL
- img_path_main — varchar(256)
- img_path_back — varchar(256)
- description — text
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
- mig_no — int
tb_event_detail
- event_seq — int — Foreign key → tb_event.event_seq — NOT NULL
- detail_seq — int — NOT NULL
- type — varchar(30) — NOT NULL
- target_seq — int — NOT NULL
- reg_dt — datetime — NOT NULL
tb_function_payment
- user_id — varchar(128) — Primary key — NOT NULL — user id
- pay_key — varchar(256) — Primary key — NOT NULL — payment key(bill key)
- seq — int — Primary key — NOT NULL — sequence of hist
- sub_no — varchar(10) — Foreign key → tb_function_subscribe.sub_no — NOT NULL — subscribe no(yymmdd+0000)
- paid_amt — int — NOT NULL — paid amt
- tid — varchar(128) — NOT NULL — tid
- result_cd — varchar(30) — result code
- result_msg — varchar(128) — result msg
- paid_dt — varchar(20) — paid date
- reg_dt — datetime — NOT NULL — when added
tb_function_subscribe
- user_id — varchar(128) — Primary key — NOT NULL — user id
- sub_no — varchar(10) — Primary key — NOT NULL — subscribe no(yymmdd+0000)
- fn_no — varchar(15) — Foreign key → tb_functions.fn_no — NOT NULL — function no
- start_dt — varchar(10) — NOT NULL — start date
- end_dt — varchar(10) — NOT NULL — end date
- montly_pay — int — NOT NULL — montly payment price
- next_pay_dt — varchar(10) — NOT NULL — next payment date
- last_paid_dt — varchar(10) — NOT NULL — last paid date
- status_cd — varchar(30) — NOT NULL — status code (01:request,02:preparing,03:payment, 10:processing,50:end)
- mod_dt — datetime — NOT NULL — when modified
- reg_dt — datetime — NOT NULL — when added
tb_functions
- fn_no — varchar(15) — Primary key — NOT NULL — function no
- title — varchar(30) — NOT NULL — function title
- type_cd — varchar(30) — NOT NULL — function type
- icon_path — varchar(256) — NOT NULL — function icon path
- exp — varchar(1024) — function explain
- desc1 — varchar(1024) — function description 1
- desc2 — varchar(1024) — function description 2
- desc3 — varchar(1024) — function description 3
- price — int — NOT NULL — function price
- dev_by — varchar(64) — developed by
- device_type — varchar(30) — NOT NULL — can use device type
- reg_dt — datetime — NOT NULL — when added
- use_yn — varchar(1) — NOT NULL — use yn
- call_function — varchar(20) — calling function
tb_magazine
- mag_seq — int — Primary key — NOT NULL
- ho — int — NOT NULL
- title — varchar(255) — NOT NULL
- st_date — varchar(15) — NOT NULL
- ed_date — varchar(15) — NOT NULL
- location — varchar(128) — NOT NULL
- summary — text
- invite_url — varchar(256)
- event — text
- hash_tags — varchar(256)
- movie_url — varchar(128)
- use_yn — varchar(1)
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_magazine_file
- mag_seq — int — Foreign key → tb_magazine.mag_seq — NOT NULL
- file_seq — int — NOT NULL
- file_snm — varchar(128) — NOT NULL
- file_rnm — varchar(128) — NOT NULL
- file_path — varchar(512) — NOT NULL
- file_type — varchar(30)
- file_ext — varchar(30)
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_magazine_space
- mag_seq — int — Foreign key → tb_magazine.mag_seq — NOT NULL
- space_seq — int — Foreign key → tb_space.space_seq — NOT NULL
- reg_dt — datetime — NOT NULL
tb_menu
- menu_cd — varchar(30) — Primary key — NOT NULL — menu code
- menu_nm — varchar(64) — NOT NULL — menu name
- p_menu_cd — varchar(30) — parent menu code
- use_yn — varchar(10) — NOT NULL — use yn
- link — varchar(128) — NOT NULL — link
tb_module_details
- module_type — varchar(30) — Primary key — NOT NULL — module type
- module_id — varchar(30) — Foreign key → tb_modules.module_id — NOT NULL — module id
- type_nm — varchar(64) — NOT NULL — type name
- type_exp — varchar(256) — type explain
- price — int — NOT NULL — price of type
tb_module_files
- hist_seq — int — Primary key — NOT NULL — sequemce of history
- req_no — varchar(10) — Foreign key → tb_module_request.req_no — NOT NULL — request no(yymmdd+0000)
- file_path — varchar(256) — NOT NULL — file path
- file_type — varchar(30) — NOT NULL — 01:normal, 02:sign
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL — when added
tb_module_request
- req_no — varchar(10) — Primary key — NOT NULL — request no(yymmdd+0000)
- user_id — varchar(128) — NOT NULL — user id
- module_id — varchar(30) — Foreign key → tb_module_details.module_id — NOT NULL — module id
- module_type — varchar(30) — Foreign key → tb_module_details.module_type — NOT NULL — module type
- attr1 — varchar(30) — option 01
- attr2 — varchar(30) — option 02
- attr3 — varchar(30) — option 03
- attr4 — varchar(30) — option 04
- attr5 — varchar(30) — option 05
- status_cd — varchar(30) — status code
- price — int — NOT NULL — price of request
- reg_dt — datetime — NOT NULL — when added
- mod_id — varchar(128) — NOT NULL — who modified
- mod_dt — datetime — NOT NULL — when modified
- space_nm — varchar(64) — space name
- busi_no — varchar(20) — business no
- ceo — varchar(64) — ceo
- mng_nm — varchar(64) — manager name
- mng_tel — varchar(15) — manager tel
- space_loc — varchar(128) — install location
- req_st_dt — varchar(10) — start date
- req_ed_dt — varchar(10) — end date
- monthly_pay — int — NOT NULL — monthly pay price
tb_module_subscribe
- sub_no — varchar(10) — Primary key — NOT NULL — subscribe no(yymmdd+0000)
- user_id — varchar(128) — NOT NULL — user id
- module_id — varchar(30) — Foreign key → tb_module_details.module_id — NOT NULL — module id
- module_type — varchar(30) — Foreign key → tb_module_details.module_type — NOT NULL — module type
- req_no — varchar(10) — Foreign key → tb_module_request.req_no — NOT NULL — request no(yymmdd+0000)
- pay_price — int — NOT NULL — pay_price
- last_paid_dt — varchar(8) — last paid date
- next_pay_dt — varchar(8) — next pay date
- status_cd — varchar(30) — NOT NULL — status code
- reg_dt — datetime — NOT NULL — when added
- mod_id — varchar(128) — NOT NULL — who modified
- mod_dt — datetime — NOT NULL — when modified
- is_tester — varchar(1) — is tester
- start_dt — varchar(10) — NOT NULL — start date
- end_dt — varchar(10) — NOT NULL — end date
tb_modules
- module_id — varchar(30) — Primary key — NOT NULL — module id
- module_nm — varchar(64) — NOT NULL — module name
- use_yn — varchar(1) — NOT NULL — use yn
tb_mrk_build
- mrk_no — varchar(15) — Primary key — NOT NULL — build no
- pre_id — varchar(128) — NOT NULL — premium id
- title — varchar(256) — NOT NULL — marketing title
- type — varchar(30) — NOT NULL — marketing type
- status_cd — varchar(30) — NOT NULL — 01 : 일시정지 , 10 : 진행중
- reg_dt — datetime — NOT NULL — when added
- mod_dt — datetime — NOT NULL — when modified
- sms_cnt — int — NOT NULL — sms send count
- visit_cnt — int — NOT NULL — site visit count
tb_mrk_cust
- seq — int — Primary key — NOT NULL — sequence
- mrk_no — varchar(15) — Foreign key → tb_mrk_build.mrk_no — NOT NULL — build no
- cust_type — varchar(20) — customer type
- tel — varchar(15) — NOT NULL — customer tel
- cust_nm — varchar(30) — customer name
- cust_email — varchar(128) — customer email
- reg_dt — datetime — NOT NULL — when added
tb_mrk_site
- path — varchar(30) — Primary key — NOT NULL — site path
- mrk_no — varchar(15) — Foreign key → tb_mrk_build.mrk_no — NOT NULL — build no
- brand_nm — varchar(30) — NOT NULL — brand name
- html_context — text — NOT NULL — html_context
- html_path — varrchar(128)
- exp_dt — varchar(15) — NOT NULL — expiry date
- reg_dt — datetime — NOT NULL — when added
- mod_dt — datetime — NOT NULL — when modified
tb_mrk_sms
- mrk_no — varchar(15) — Foreign key → tb_mrk_build.mrk_no — NOT NULL — build no
- sender — varchar(15) — NOT NULL — sender
- context — text — NOT NULL — context
- resv_dt — varchar(15) — reserve time
- reg_dt — datetime — NOT NULL — when added
- sms_type — varchar(30) — NOT NULL — sms tyle(A : 광고성, B:정보성)
tb_msg_action
- pre_id — varchar(128) — Primary key — NOT NULL — premium id
- action_id — varchar(30) — Primary key — NOT NULL — action id
- type — varchar(30) — NOT NULL — action type(S:SMS, K: kakao)
- sms_temp_no — varchar(15) — sms template no
- kakao_temp_no — varchar(15) — kakao talk template no
- reg_dt — datetime — NOT NULL — when added
tb_page_access_hist
- page_url — varchar(128) — Primary key — NOT NULL
- base_dt — varchar(12) — Primary key — NOT NULL
- count — int — NOT NULL
- reg_id — varchar(128)
- reg_dt — datetime — NOT NULL
tb_payment
- book_seq — int — Foreign key → tb_space_book.book_seq — NOT NULL
- oid — varchar(128) — NOT NULL
- goods_name — varchar(128)
- price — int — NOT NULL
- tax — int
- currency — varchar(30)
- buyer_nm — varchar(128)
- buyer_tel — varchar(128)
- buyer_email — varchar(128)
- result_code — varchar(10)
- result_msg — varchar(128)
- final_price — int
- pay_method — varchar(30)
- apply_dt — varchar(12)
- apply_time — varchar(12)
- tid — varchar(128)
- card_num — varchar(128)
- card_interest — varchar(30)
- card_quota — varchar(30)
- card_code — varchar(30)
- card_bank_code — varchar(30)
- card_src_code — varchar(30)
- reg_dt — datetime — NOT NULL
- reg_id — varchar(128) — NOT NULL
tb_payment_cancel
- book_seq — int — Foreign key → tb_space_book.book_seq — NOT NULL
- goods_name — varchar(128) — NOT NULL
- total_price — int — NOT NULL
- refund_price — int — NOT NULL
- req_memo — text
- req_dt — datetime — NOT NULL
- refund_dt — datetime
- tid — varchar(256) — NOT NULL
- etc — varchar(512)
- result_code — varchar(10)
- result_msg — varchar(128)
- cshr_cancel — varchar(128)
- req_id — varchar(128) — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_payment_mng
- user_id — varchar(128) — Foreign key → tb_payment_request.user_id — NOT NULL — user_id
- req_no — varchar(10) — Foreign key → tb_payment_request.req_no — NOT NULL — request no
- req_type — varchar(30) — NOT NULL — type(01:nice,02:kicc)
- van_id — varchar(10) — van id
- pg_id — varchar(30) — pg id
- pg_attr1 — varchar(256) — attributre 1
- pg_attr2 — varchar(256) — attribute 2
- pg_attr3 — varchar(256) — attribute3
- reg_id — varchar(128) — NOT NULL — who added
- reg_dt — datetime — NOT NULL — when added
- mod_id — varchar(128) — NOT NULL — who modified
- mod_dt — datetime — NOT NULL — when modified
tb_payment_request
- user_id — varchar(128) — Primary key — NOT NULL — user_id
- req_no — varchar(10) — Primary key — NOT NULL — request no
- req_type — varchar(30) — NOT NULL — type(01:nice,02:kicc)
- comp_nm — varchar(60) — NOT NULL — company name
- busi_no — varchar(10) — NOT NULL — business no
- ceo — varchar(50) — NOT NULL — ceo
- ceo_birth — varchar(8) — NOT NULL — ceo birth
- corp_kind — varchar(10) — NOT NULL — company type(P:personal, C:corperation)
- corp_no — varchar(13) — corp no
- comp_type — varchar(200) — NOT NULL — company type
- comp_ctgr — varchar(50) — NOT NULL — company category
- tax_type — varchar(1) — NOT NULL — tax type (Y:tax,N:zero tax)
- tel_no — varchar(15) — tel no
- fax_no — varchar(15) — fax no
- zip_cd — varchar(6) — NOT NULL — zip code
- addr — varchar(150) — NOT NULL — address
- addr_detail — varchar(150) — NOT NULL — address detail
- main_tel_no — varchar(15) — NOT NULL — main tel no
- main_email — varchar(100) — NOT NULL — main email
- shop_nm — varchar(50) — NOT NULL — shop name
- shop_url — varchar(100) — NOT NULL — shop url
- status_cd — varchar(2) — NOT NULL — status code (01:request)
- reg_dt — datetime — NOT NULL — when added
- reg_id — varchar(128) — NOT NULL — who added
- mod_dt — datetime — NOT NULL — when modified
- mod_id — varchar(128) — NOT NULL — who modified
tb_popular
- pop_seq (Key) — int — Primary key — NOT NULL
- hash_tag — varchar(30) — NOT NULL
- img_path_main — varchar(256)
- img_path_back — varchar(256)
- use_yn — varchar(1) — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_popular_detail
- pop_seq (Key) — int — Foreign key → tb_popular.pop_seq — NOT NULL
- space_seq — int — Foreign key → tb_space.space_seq — NOT NULL
- reg_dt — datetime — NOT NULL
tb_premium
- pre_id — varchar(128) — Primary key — NOT NULL
- user_id — varchar(128) — NOT NULL
- agree_type — varchar(30) — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
- lotte_yn — varchar(1)
- cafe24_yn — varchar(1)
- widget_yn — varchar(1)
- short_id — varchar(30) — premium user id
- source — varchar(30) — source
- microsite_yn — varchar(1) — microsite use yn
- parent_pre_id — varchar(128) — parent premium id
tb_premium_board
- board_seq — int — Primary key — NOT NULL
- mng_id — varchar(128)
- ctgr_cd — varchar(30) — NOT NULL
- title — varchar(256) — NOT NULL
- context — text — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
- start_dt — varchar(8) — notice date
- end_dt — varchar(8) — notice date
tb_premium_board_file
- file_seq — int — Primary key — NOT NULL
- board_seq — int — Foreign key → tb_premium_board.board_seq — NOT NULL
- file_path — varchar(128) — NOT NULL
- file_save_nm — varchar(128) — NOT NULL
- file_real_nm — varchar(128) — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_premium_board_reply
- reply_seq — int — Primary key — NOT NULL
- board_seq — int — Foreign key → tb_premium_board.board_seq — NOT NULL
- context — text
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_premium_board_status
- board_seq — int — Foreign key → tb_premium_board.board_seq — NOT NULL
- status_cd — varchar(30) — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_premium_chat_hist
- chat_seq — int — NOT NULL
- u_from — varchar(128) — NOT NULL
- u_to — varchar(128) — NOT NULL
- msg — text — NOT NULL
- read_yn — varchar(1) — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_premium_menu
- pre_id — varchar(128) — Foreign key → tb_premium.pre_id — NOT NULL
- is_cafe24_mnt — varchar(1)
- is_lotte_mnt — varchar(1)
- is_widget_mnt — varchar(1)
- is_order_mnt — varchar(1)
- is_inv_mnt — varchar(1)
- is_agree_mnt — varchar(1)
- is_prod_mnt — varchar(1)
- is_stock_mnt — varchar(1)
- is_adv_mnt — varchar(1)
- is_sales_mnt — varchar(1)
- is_chat — varchar(1)
- is_tax_mnt — varchar(1)
- is_dashboard — varchar(1)
tb_premium_store
- store_seq — int — Primary key — NOT NULL
- pre_id — varchar(128) — Foreign key → tb_premium.pre_id — NOT NULL
- store_nm — varchar(128) — NOT NULL
- pos_nm — varchar(128) — NOT NULL
- brand_cd — varchar(5) — NOT NULL
- mng_id — varchar(128) — NOT NULL
- mng_nm — varchar(128)
- mng_tel — varchar(20)
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_premium_store_sales
- seq — int — NOT NULL
- prod_nm — varchar(128) — NOT NULL
- ctgr_nm — varchar(128) — NOT NULL
- store_nm — varchar(128) — NOT NULL
- sales_price — int
- sales_cnt — int
- salse_dt — varchar(10)
- reg_dt — datetime — NOT NULL
tb_proc_board
- proc_cd — varchar(30) — Primary key — NOT NULL
- book_seq — int — Foreign key → tb_space_book.book_seq — NOT NULL
- content — text — NOT NULL
- refuse_text — text
- refuse_dt — datetime
- exp_dt — varchar(10)
- mod_id — varchar(128)
- mod_dt — datetime
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_proc_board_file
- hist_seq — int — Primary key — NOT NULL
- proc_cd — varchar(30) — Foreign key → tb_proc_board.proc_cd — NOT NULL
- book_seq — int — Foreign key → tb_proc_board.book_seq — NOT NULL
- file_path — varchar(128) — NOT NULL
- file_save_nm — varchar(128) — NOT NULL
- file_real_nm — varchar(128) — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_prod_survey
- seq — int — Primary key — NOT NULL
- prod_seq — int — Foreign key → tb_product.prod_seq — NOT NULL
- prod_survey_seq — int — NOT NULL
- sexual — varchar(30)
- phone — varchar(30)
- ages — varchar(30)
- score — int
- like_yn — varchar(1)
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_product
- prod_seq — int — Primary key — NOT NULL
- pre_id — varchar(128) — Foreign key → tb_premium.pre_id — NOT NULL
- prod_nm — varchar(128) — NOT NULL
- base_price — int — NOT NULL
- sale_price — int — NOT NULL
- description — text
- video_rul — varchar(512)
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_product_file
- file_seq — int — Primary key — NOT NULL
- prod_seq — int — Foreign key → tb_product.prod_seq — NOT NULL
- file_type — varchar(30) — NOT NULL
- file_sav_nm — varchar(128) — NOT NULL
- file_real_nm — varchar(128) — NOT NULL
- file_path — varchar(256) — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_push_token
- user_id — varchar(128) — Foreign key — NOT NULL — user id
- reg_id — varchar(128) — NOT NULL — who added
- reg_dt — datetime — NOT NULL — when added
- mod_id — varchar(128) — NOT NULL — who modified
- mod_dt — datetime — NOT NULL — when modified
- token — varchar(128) — NOT NULL — token
tb_quest
- q_seq — int — NOT NULL
- comp_nm — varchar(128) — NOT NULL
- mng_nm — varchar(30) — NOT NULL
- tel — varchar(30)
- homepage — varchar(256)
- context — text
- type — varchar(30)
- acquisition — varchar(256)
- reg_id — varchar(128)
- reg_dt — datetime — NOT NULL
- busi_nm — varchar(100)
- location — varchar(100)
- email — varchar(128)
tb_recuring_hist
- book_seq — int — Foreign key → tb_space_book.book_seq — NOT NULL
- hist_seqh (hist_seq) — int — NOT NULL
- bill_key — varchar(256) — NOT NULL
- amt — int — NOT NULL
- tid — varchar(128) — NOT NULL
- result_cd — varchar(30) — NOT NULL
- result_msg — varchar(128)
- auth_dt — varchar(20)
- card_cd — varchar(30)
- card_nm — varchar(128)
- expected_date — varchar(12) — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
- can_dt — varchar(15)
- can_amt — int
- can_result_cd — varchar(30)
- can_result_msg — varchar(128)
- can_tid — varchar(128)
tb_recuring_payment
- space_seq — int — Foreign key → tb_space_book.space_seq — NOT NULL
- Key — Foreign key → tb_space_book.book_seq — NOT NULL
- moid — varchar(128) — NOT NULL
- bill_key — varchar(256) — NOT NULL
- bill_st_date — varchar(12) — NOT NULL
- bill_ed_date — varchar(12) — NOT NULL
- bill_month — int — NOT NULL
- bill_price — int — NOT NULL
- goods_nm — varchar(128)
- card_code — varchar(30)
- card_nm — varchar(128)
- buyer_nm — varchar(128) — NOT NULL
- buyer_email — varchar(128) — NOT NULL
- buer_tel — varchar(15) — NOT NULL
- card_interest — varchar(30)
- card_quota — varchar(30)
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_self_popup
- seq — int — NOT NULL
- book_seq — int — Foreign key → tb_space_book.book_seq — NOT NULL
- req_nm — varchar(64) — NOT NULL
- req_tel — varchar(14) — NOT NULL
- req_email — varchar(128) — NOT NULL
- req_homepage — varchar(128) — NOT NULL
- req_sns — varchar(128) — NOT NULL
- req_detail — text
- req_layer — varchar(30)
- req_condition — varchar(30)
- req_id — varchar(128) — NOT NULL
- req_dt — datetime — NOT NULL
tb_short_url
- seq — int — NOT NULL — 일련번호
- short_url — varchar(128) — NOT NULL — 짧은주소
- redirect_url — varchar(512) — NOT NULL — 재이동 주소
- is_login_required — varchar(1) — 로그인 필수 여부
- login_id — varchar(128) — 로그인 아이디
- expired_dt — varchar(15) — 만료일자
- reg_id — varchar(128) — NOT NULL — 등록 아이디
- reg_dt — datetime — NOT NULL — 등록일자
tb_sms_template
- temp_no — varchar(15) — Primary key — NOT NULL — template no
- pre_id — varchar(128) — Foreign key → tb_brand_caller.pre_id — NOT NULL — premium id
- caller_id — varchar(15) — Foreign key → tb_brand_caller.caller_id — NOT NULL — calling number
- title — varchar(64) — NOT NULL — title
- context — text — NOT NULL — template context
- reg_dt — datetime — NOT NULL — when added
- mod_dt — datetime — NOT NULL — when modified
tb_space
- space_seq — int — Primary key — NOT NULL
- ltype — varchar(30) — NOT NULL
- mtype — varchar(30)
- country — varchar(30)
- city — varchar(128)
- addr — varchar(256)
- loc_exp — varchar(512)
- name — varchar(128)
- build_type — varchar(30)
- area — varchar(30)
- floor — varchar(10)
- min_rent — varchar(10)
- rent_type — varchar(30)
- start_dt — varchar(12)
- end_dt — varchar(12)
- start_time — varchar(5)
- end_time — varchar(5)
- rule — text
- start_week_pop — varchar(5)
- end_week_pop — varchar(5)
- start_weekend_pop — varchar(5)
- end_weekend_pop — varchar(5)
- prc_per_day_week — int
- prc_per_day_weekend — int
- same_prc_yn — varchar(1)
- unit — varchar(30)
- fee_yn — varchar(1)
- status — varchar(30)
- view_cnt — int
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
- mig_sp_no — int
- use_yn — varchar(1)
- sexual — varchar(30)
- temp_yn — varchar(1)
- recom_goods — text
- good_things — text
- prohibite_goods — text
- vr_path — varchar(255)
- sp_store_yn — varchar(1)
- hash_tag — varchar(128)
- space_logo_path — varchar(256)
- integ_key — varchar(30) — 연동 상점키
- short_id — vharchar(20) — 공간단축아이디
- passcode — varchar(6) — 매장 키오스크 비밀번호
- idle_dsp_time — int — 대기화면 시간
- idle_dsp_yn — varchar(1) — 대기화면 사용여부
- cafe24_store_yn — varchar(1) — cafe24 매장 여부
- zipcode — varchar(6) — zipcode
tb_space_block
- block_seq — int — Primary key — NOT NULL
- space_seq — int — Foreign key → tb_space.space_seq — NOT NULL
- b_st_date — varchar(12) — NOT NULL
- b_end_date — varchar(12) — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_space_book
- book_seq — int — Primary key — NOT NULL
- space_seq — int — Foreign key → tb_space.space_seq — NOT NULL
- req_nm — varchar(128) — NOT NULL
- req_tel — varchar(30)
- req_email — varchar(128)
- req_memo — text
- req_homepage — varchar(128) — NOT NULL
- req_sns — varchar(128)
- agree_yn — varchar(1)
- book_st_date — varchar(10)
- book_ed_date — varchar(10)
- book_status — varchar(30) — NOT NULL
- confirm_st_date — varchar(10)
- confirm_ed_date — varchar(10)
- book_price — int
- req_sp_month — int
- req_sp_type_cd — varchar(30)
- req_sp_opt_cd — varchar(30) — NOT NULL
- reg_dt — datetime — NOT NULL
- popup_yn — varchar(1) — 팝업부스 신청여부
- flag_yn — varchar(1) — 플래그쉽 신청여부
- sp_expired_dt — varchr(15) — 특수만료일자
- contract_file — varchar(128) — 계약서 이미지
- sign_file — varchar(128) — 서명 이미지
tb_space_ext_item
- item_no — varchar(64) — Primary key — NOT NULL — item no
- item_type — varchar(30) — Primary key — NOT NULL — item type
- space_seq — int — Foreign key → tb_space.space_seq — NOT NULL
- html_content — varchar(512) — NOT NULL — html_content
- ltype — varchar(30) — NOT NULL — space ltype
- reg_dt — datetime — NOT NULL — when added
- mod_dt — datetime — NOT NULL — when modified
tb_space_favorite
- fav_seq — int — Primary key — NOT NULL
- space_seq — int — Foreign key → tb_space.space_seq — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_space_file
- file_seq — int — Primary key — NOT NULL
- space_seq — int — Foreign key → tb_space.space_seq — NOT NULL
- file_snm — varchar(128) — NOT NULL
- file_rnm — varchar(128) — NOT NULL
- file_path — varchar(512) — NOT NULL
- file_type — varchar(30) — NOT NULL
- file_ext — varchar(30)
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_space_option
- space_seq (space_seq2) — int — Foreign key → tb_space.space_seq — NOT NULL
- opt_seq — int — NOT NULL
- opt_code — varchar(30) — NOT NULL
- opt_value — varchar(256)
- opt_etc — varchar(512)
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_space_pg
- user_id — varchar(128) — Primary key — NOT NULL — brand user id
- space_seq — int — Foreign key → tb_space.space_seq — NOT NULL
- cat_id — varchar(10) — cat id
- van_id — varchar(10) — van id
- mod_id — varchar(128) — NOT NULL — who modified
- mod_dt — datetime — NOT NULL — when modified
tb_subscribe
- sub_seq — int — NOT NULL
- name — varchar(128) — NOT NULL
- email — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_survey_answer
- answer_seq — int — Primary key — NOT NULL
- survey_seq (survey_seq2) — int — Foreign key — NOT NULL
- prod_seq — int — Foreign key — NOT NULL
- point_of_answer — varchar(30) — NOT NULL
- reg_id — varchar(128) — NOT NULL
- reg_dt — datetime — NOT NULL
- prod_survey_seq — int
and 8 more tables