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