nail-art

Tables (14)

tb_board

  • board_seq — int — Primary key — NOT NULL — sequence of board
  • board_type — varchar(30) — NOT NULL — type of board
  • subject — varchar(256) — NOT NULL — subject of board
  • context — text — NOT NULL — context of board
  • first_nm — varchar(128) — first_nm of writer
  • last_nm — varchar(128) — last nm of writer
  • email — varchar(256) — email of writer
  • 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_board_file

  • file_seq — int — Primary key — NOT NULL — sequence of file
  • board_seq — int — Foreign key → tb_board.board_seq — NOT NULL — sequence of board
  • file_real_nm — varchar(256) — NOT NULL — name of file for real
  • file_save_nm — varchar(256) — NOT NULL — name of file for storage
  • file_path — varchar(256) — NOT NULL — path of storage
  • 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_nail_images

  • img_seq — int — Primary key — NOT NULL — image sequnce
  • name — varchar(128) — NOT NULL — name of images
  • img_path — varchar(128) — NOT NULL — image path
  • ctgr_cd — varchar(30) — NOT NULL — category code
  • is_md — varchar(1) — NOT NULL — md rcomanded
  • is_new — varchar(1) — NOT NULL — new images
  • reg_id — varchar(128) — NOT NULL — added by
  • 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) — option type
  • 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_order

  • ord_no — varchar(128) — Primary key — NOT NULL — order no
  • req_nm — varchar(60) — NOT NULL — request name
  • req_email — varchar(128) — NOT NULL — request email
  • req_tel — varchar(15) — NOT NULL — request tel
  • rec_nm — varchar(60) — NOT NULL — recieve name
  • rec_tel — varchar(15) — NOT NULL — receive tel
  • addr — varchar(256) — NOT NULL — address
  • addr_detail — varchar(256) — address detail
  • zip_code — varchar(10) — NOT NULL — zipcode
  • city — varchar(128) — NOT NULL — city of state
  • country — varchar(60) — NOT NULL — country of delivery
  • state — varchar(10) — NOT NULL — state of country
  • status_cd — varchar(30) — NOT NULL — status code of ordering
  • delivery_comp_cd — varchar(30) — delivery company code
  • delivery_no — varchar(128) — delivery no
  • memo — varchar(512) — memo
  • total_price — decimal(10,2) — NOT NULL — total price
  • ship_price — deciaml(10,2) — NOT NULL — shipping price
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on

tb_order_image

  • img_seq — int — Primary key — NOT NULL — image sequnce
  • ord_no — varchar(128) — Foreign key → tb_order.ord_no — NOT NULL — order no
  • price — decimal(10,2) — NOT NULL — price of product
  • img_path — varchar(256) — NOT NULL — image path
  • count — int — NOT NULL — quentity of product
  • reg_dt — datetime — NOT NULL — added on

tb_short_url

  • redirect_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_store

  • store_id — varchar(30) — Primary key — NOT NULL — store id
  • store_nm — varchar(128) — NOT NULL — name
  • open_hour — varchar(128) — open hour
  • open_info — varchar(128) — opening infomation
  • context — text — context
  • store_type — varchar(30) — NOT NULL — store type
  • 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

tb_store_file

  • seq — int — Primary key — NOT NULL — sequnce
  • store_id — varchar(30) — Foreign key → tb_store.store_id — NOT NULL — store id
  • file_path — varchar(256) — NOT NULL — file path
  • 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

  • user_id — varchar(128) — Primary key — NOT NULL — user id
  • password — varchar(512) — NOT NULL — user password
  • first_nm — varchar(128) — NOT NULL — first name
  • last_nm — varchar(128) — NOT NULL — last_name
  • tel — varchar(20) — phone number
  • reg_dt — datetime — NOT NULL — date of registry

tb_user_point

  • hist_seq — int — Primary key — NOT NULL — sequnce of history
  • user_id — varchar(128) — Foreign key → tb_user.user_id — NOT NULL — user id
  • point — decimal(10, 2) — NOT NULL — point of user which is paid
  • description — text — describe that when use point
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on

tb_user_role

  • user_id — varchar(128) — Foreign key → tb_user.user_id — NOT NULL — user id
  • user_role — varchar(30) — NOT NULL — user role
  • mod_id — varchar(128) — NOT NULL — modified by
  • mod_dt — datetime — NOT NULL — modified on