BRING
Tables (19)
tb_category
- ctgr_cd — varchar(30) — Primary key — NOT NULL — category code
- ctgr_seq — int — Primary key — NOT NULL — category seq
- type — varchar(30) — NOT NULL — category type(01:model,02:prod)
- img_path — varchar(256) — NOT NULL — image path
- pno — varchar(30) — product no
- md_seq — int — NOT NULL — model seq
- use_yn — varchar(30) — NOT NULL — use yn
- sort — int — NOT NULL — sort
- reg_id — varchar(128) — NOT NULL — added by
- reg_dt — datetime — NOT NULL — added on
tb_code
- code — varchar(30) — Primary key — NOT NULL — code
- type_code — varchar(30) — Foreign key → tb_type_code.type_code — NOT NULL — type of code
- p_code — varchar(30) — parent code
- value — varchar(128) — NOT NULL — value of code
- sort — int — NOT NULL — priority of code
- use_yn — varchar(1) — use yn
- mod_id — varchar(128) — NOT NULL — user who modified data
- mod_dt — datetime — NOT NULL — date when modified data
- reg_id — varchar(129) — NOT NULL — user who registed data
- reg_dt — datetime — NOT NULL — date when registed data
tb_faq
- faq_seq — int — Primary key — NOT NULL — faq seq
- quest — varchar(128) — NOT NULL — quest of faq
- answer — varchar(512) — NOT NULL — answer the quest
- use_yn — varchar(30) — NOT NULL — use yn
- mod_id — varchar(128) — NOT NULL — modified by
- mod_dt — datetime — NOT NULL — modified on
- reg_id — varchar(128) — NOT NULL — added by
- reg_dt — datetime — NOT NULL — added on
tb_fitting_prod
- fit_no — varchar(30) — Foreign key → tb_fitting_room.fit_no — NOT NULL — fitting no
- pno — varchar(30) — Foreign key → tb_product_size.pno — NOT NULL — product no
- size_cd — varchar(30) — Foreign key → tb_product_size.size_cd — NOT NULL — size code
- qty — int — NOT NULL — quentity of product
- price — int — NOT NULL — price of product
- return_yn — varchar(1) — return yn
- return_dt — datetime — date of request of return
- cofnirm_yn (confirm_yn) — varchar(1) — confirm yn
- confirm_dt — datetime — date of confirm date
- reg_id — varchar(128) — NOT NULL — added by
- reg_dt — datetime — NOT NULL — added on
- mod_id — varchar(128) — NOT NULL — modified by
- mod_dt — datetime — NOT NULL — modified on
- paid_yn — varchar(1) — paid yn
- paid_dt — datetime — paid date
tb_fitting_room
- fit_no — varchar(30) — Primary key — NOT NULL — fitting no
- email — varchar(128) — Foreign key → tb_user.email — NOT NULL — user email
- addr_seq — int — Foreign key → tb_user_addr.addr_seq — NOT NULL — sequnce of address
- card_seq — int — Foreign key → tb_user_card.card_seq — NOT NULL — sequence of card
- rtn_addr_seq — int — return addr_seq
- buy_card_seq — int — buy_card_seq
- price — int — price
- status_cd — varchar(30) — NOT NULL — status code
- req_dt — datetime — request date
- pay_id — varchar(128) — payment id
- reg_id — varchar(128) — NOT NULL — added by
- reg_dt — datetime — NOT NULL — added on
- receipt_path — varchar(256) — receipt path
tb_model
- md_seq — int — Primary key — NOT NULL — model seq
- name — varchar(128) — NOT NULL — model name
- main_img_path — varchar(256) — NOT NULL — main model images
- reg_id — varchar(128) — NOT NULL — added by
- reg_dt — datetime — NOT NULL — added on
tb_model_file
- seq — int — Primary key — NOT NULL — model file seq
- md_seq — int — Foreign key → tb_model.md_seq — NOT NULL — model seq
- file_path — varchar(128) — NOT NULL — model image path
- reg_dt — datetime — NOT NULL — added on
tb_option
- opt_key — varchar(128) — Primary key — NOT NULL — key of option
- opt_value — varchar(128) — NOT NULL — value of option
- opt_explain — varchar(128) — NOT NULL — dsciption of optopn
- opt_type — varchar(30) — type of option
- mod_id — varchar(128) — NOT NULL — who modified data
- mod_dt — datetime — NOT NULL — when modified data
- reg_id — varchar(128) — NOT NULL — who registed data
- reg_dt — datetime — NOT NULL — when registed data
tb_payment_hist
- email — varchar(128) — Primary key — NOT NULL — user id
- moid — varchar(128) — Primary key — NOT NULL — order id
- bill_key — varchar(512) — NOT NULL — bill key
- tid — varchar(256) — NOT NULL — deal id
- amt — int — NOT NULL — price
- goods — varchar(128) — name of product
- auth_cd — varchar(30) — NOT NULL — auth code
- auth_dt — varchar(20) — NOT NULL — auth date
- result_cd — varchar(30) — NOT NULL — result code
- result_msg — varchar(512) — NOT NULL — result message
- paid_type — varchar(30) — NOT NULL — paid type
- fit_no — varchar(30) — NOT NULL — fit no
- pno — varchar(30) — product no
- size_cd — varchar(30) — size code
- reg_id — varchar(128) — NOT NULL — added by
- reg_dt — datetime — NOT NULL — added on
tb_product
- pno — varchar(30) — Primary key — NOT NULL — product no
- name — varchar(128) — NOT NULL — name of product
- price — int — NOT NULL — price of product
- main_image_path — varchar(256) — NOT NULL — main image path
- status_cd — varchar(30) — NOT NULL — status code
- context — text — context
- reg_id — varchar(128) — NOT NULL — added by
- color_cd — varchar(30) — NOT NULL — color code
- reg_dt — datetime — NOT NULL — added on
- mod_id — varchar(128) — NOT NULL — modified by
- mod_dt — datetime — NOT NULL — modified on
tb_product_file
- file_seq — int — Primary key — NOT NULL — sequnce of file
- pno — varchar(30) — Foreign key → tb_product.pno — NOT NULL — product no
- file_path — varchar(256) — NOT NULL — file path
- reg_dt — datetime — NOT NULL — added on
tb_product_size
- size_cd — varchar(30) — Primary key — NOT NULL — size code
- pno — varchar(30) — Foreign key → tb_product.pno — NOT NULL — product no
- qty — int — NOT NULL — quentity of size of product
- reg_dt — datetime — NOT NULL — added by
tb_return
- fit_no — varchar(30) — Foreign key → tb_fitting_prod.fit_no — NOT NULL — fitting no
- pno — varchar(30) — Foreign key → tb_fitting_prod.pno — NOT NULL — product no
- size_cd — varchar(30) — Foreign key → tb_fitting_prod.size_cd — NOT NULL — size code
- qty — int — NOT NULL — quentity of product
- msg — varchar(512) — message
- addr_seq — int — return address seq
- status_cd — varchar(30) — NOT NULL — status code
- reg_id — varchar(128) — NOT NULL — added by
- reg_dt — datetime — NOT NULL — added on
tb_short_url
- redirect_url — varchar(128) — Primary key — NOT NULL — short url
- short_url — varchar(128) — Primary key — NOT NULL — short_url
- is_login_required — varchar(1) — require to login
- login_id — varchar(128) — login id
- expired_dt — varchar(15) — expired date
- reg_id — varchar(128) — NOT NULL — added by
- reg_dt — datetime — NOT NULL — added on
tb_type_code
- type_code — varchar(30) — Primary key — NOT NULL — type of code
- p_type_code — varchar(30) — parent type code
- value — varchar(128) — NOT NULL — discribe type_code
- use_yn — varchar(1) — use yn
- mod_id — varchar(128) — NOT NULL — who modified data
- mod_dt — datetime — NOT NULL — when modified data
- reg_id — varchar(128) — NOT NULL — who registed data
- reg_dt — datetime — NOT NULL — when registed data
tb_user
- email — varchar(128) — Primary key — NOT NULL — user email
- password — varchar(512) — NOT NULL — user password
- name — varchar(56) — NOT NULL — name of user
- tel — varchar(15) — NOT NULL — tel
- use_agree_yn — varchar(1) — NOT NULL — agree yn
- collect_agree_yn — varchar(1) — NOT NULL — collect personal information
- join_dt — datetime — NOT NULL — date time
tb_user_addr
- addr_seq — int — Primary key — NOT NULL — sequnce of address
- email — varchar(128) — Foreign key → tb_user.email — NOT NULL — user email
- rec_nm — varchar(56) — NOT NULL — name of receive
- rec_tel — varchar(15) — NOT NULL — tel
- addr — varchar(256) — NOT NULL — address
- detail — varchar(128) — address detail
- zip_cd — varchar(6) — NOT NULL — zip code
- reg_id — varchar(128) — NOT NULL — added by
- reg_dt — datetime — NOT NULL — added on
- mod_id — varchar(128) — NOT NULL — modified by
- mod_dt — datetime — NOT NULL — modified on
- delete_yn — varchar(1) — delete yn
tb_user_card
- card_seq — int — Primary key — NOT NULL — sequence of card
- email — varchar(128) — Foreign key → tb_user.email — NOT NULL — user email
- bill_key — varchar(512) — NOT NULL — bill key
- moid — varchar(64) — NOT NULL — moid for card
- name — varchar(56) — NOT NULL — name of card
- card_no — varchar(20) — NOT NULL — card number
- exp_dt — varchar(5) — NOT NULL — expired date
- card_type — varchar(30) — NOT NULL — card type
- reg_dt — datetime — NOT NULL — added on
- delete_yn — varchar(1) — delete yn
tb_user_role
- email — varchar(128) — Foreign key → tb_user.email — NOT NULL — user email
- user_role — varchar(30) — NOT NULL — user role
- reg_dt — datetime — NOT NULL — added on