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