omybrand
Tables (42)
app_info
- app_version — varchar(20) — Primary key — NOT NULL
- app_link — varchar(255) — NOT NULL
- app_updatemust — tinyint(4) — NOT NULL
artist
- artist_sn — varchar(12) — Primary key — NOT NULL — 작가 일련번호
- artist_id — varchar(255) — NOT NULL — 작가 아이디
- artist_pwd — varchar(255) — NOT NULL — 작가 비밀번호
- artist_name — varchar(24) — NOT NULL — 작가명
- artist_ment — varchar(255) — NOT NULL — 작가의 말
- artist_photo — varchar(255) — NOT NULL — 작가 프로필 사진
- artist_able — tinyint(4) — 작가 주문 가능 여부
- artist_longtime — tinyint(4) — 작가 장기간 휴식 여부
- artist_weekend — tinyint(4) — NOT NULL — 작가 주말 여부
- artist_en_name — varchar(255) — NOT NULL
- artist_en_ment — varchar(255) — NOT NULL
- artist_jp_name — varchar(255) — NOT NULL
- artist_jp_ment — varchar(255) — NOT NULL
- artist_chi_name — varchar(255) — NOT NULL
- artist_chi_ment — int(11) — NOT NULL
- artist_phone — varchar(255) — NOT NULL
- artist_nickname — varchar(255) — NOT NULL
- artist_postnum — varchar(10) — NOT NULL
- artist_addr1 — varchar(255) — NOT NULL
- artist_addr2 — varchar(255) — NOT NULL
- company_num — varchar(255) — NOT NULL
- company_name — varchar(255) — NOT NULL
- owner_name — varchar(255) — NOT NULL
- company_type — varchar(255) — NOT NULL
- company_area — varchar(255) — NOT NULL
- sell_num — varchar(255) — NOT NULL
- tax_email — varchar(255) — NOT NULL
- company_num_path — varchar(255) — NOT NULL
- sell_num_path — varchar(255) — NOT NULL
- terms_aggree — varchar(1) — NOT NULL
- trans_aggree — varchar(1) — NOT NULL
- private_aggree — varchar(1) — NOT NULL
- marketing_aggree — varchar(1) — NOT NULL
- regdate — datetime — NOT NULL
- authdate — datetime
- lastconnectDate — datetime
- rankCode — varchar(20)
- artistRank — varchar(200)
- tax_yn — varchar(1)
- grand — varchar(1) — NOT NULL
- artist_email — varchar(255)
- noprocesscnt — int(11)
- initPW — varchar(1) — NOT NULL
- bankAccount — varchar(100)
- bankNum — varchar(100)
- bankName — varchar(100)
- bankPic — varchar(255)
- idPic — varchar(255)
- request_idx — int(11) — NOT NULL
- notiYN — varchar(1) — NOT NULL
- token — varchar(255)
- block — varchar(1) — NOT NULL
- tee — double — NOT NULL
artist_auth
- id — int(11) — Primary key — NOT NULL
- requestid — int(11) — NOT NULL
- auth — varchar(255) — NOT NULL
- expiration — datetime — NOT NULL
artist_info
- artist_info_sn — int(11) — Primary key — NOT NULL
- artist_sn — varchar(12) — NOT NULL
- artist_info_year — varchar(4) — NOT NULL
- artist_info_month — varchar(4) — NOT NULL
- artist_info_content — varchar(255) — NOT NULL
- artist_info_en_content — varchar(255) — NOT NULL
- artist_info_jp_content — varchar(255) — NOT NULL
- artist_info_chi_content — varchar(255) — NOT NULL
artist_information
- artist_sn — varchar(20) — Primary key — NOT NULL
- connectTime — varchar(100)
- tools — varchar(200)
- language — varchar(200)
- weekwork — varchar(1)
- workstatus — varchar(1)
- comment_kor — text
- comment_eng — text
- comment_jp — text
- comment_chi — text
- regdate — datetime
- timeprice — int(11)
- active_category — varchar(1000)
- startuppkg — varchar(1)
- level — varchar(10)
artist_passwordinit
- idx — int(11) — Primary key — NOT NULL
- artist_sn — varchar(20) — NOT NULL
- email — varchar(100) — NOT NULL
- code — varchar(12) — NOT NULL
- processYN — varchar(1) — NOT NULL
- regdate — datetime — NOT NULL
artist_port
- artist_port_sn — int(11) — Primary key — NOT NULL — 작가 포트폴리오 일련번호
- artist_sn — varchar(12) — NOT NULL — 작가 일련번호
- artist_port — varchar(255) — NOT NULL — 작가 포트폴리오 사진
artist_request
- id — int(11) — Primary key — NOT NULL
- sallername — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- photofolio — varchar(255)
- information — text
- history — text
- link — varchar(255)
- status — varchar(1)
- requestDate — datetime
- processDate — datetime
- phone — varchar(255)
- rank — varchar(200)
- rankCode — varchar(20)
- artist_sn — varchar(20)
artist_request_file
- idx — int(11) — Primary key — NOT NULL
- requestid — int(11) — NOT NULL
- seq — int(11) — NOT NULL
- filepath — varchar(255) — NOT NULL
- regdate — datetime — NOT NULL
banner
- banner_sn — varchar(6) — Primary key — NOT NULL
- banner_path — varchar(255) — NOT NULL
- banner_link — varchar(255) — NOT NULL
banner_category
- banneridx — int(11) — Primary key — NOT NULL
- category_sn — int(11) — Primary key — NOT NULL
- regdate — datetime — NOT NULL
banner_master
- idx — int(11) — Primary key — NOT NULL
- bannerType — varchar(20) — NOT NULL
- banner_image — varchar(255) — NOT NULL
- banner_title — varchar(255)
- link — varchar(255) — NOT NULL
- regdate — datetime — NOT NULL
- useYN — varchar(10) — NOT NULL
- startDate — datetime — NOT NULL
- endDate — datetime — NOT NULL
- category — varchar(255) — NOT NULL
- langtype — varchar(10) — NOT NULL
- sort — int(11) — NOT NULL
basket
- basketSN — varchar(20) — Primary key — NOT NULL
- baseID — varchar(20) — NOT NULL
- user_sn — varchar(20) — NOT NULL
- regdate — datetime — NOT NULL
- ordertype — varchar(10) — NOT NULL
basketitem
- idx — int(11) — Primary key — NOT NULL
- basketSN — varchar(20) — NOT NULL
- baseID — varchar(20) — NOT NULL
- product_sn — varchar(20) — NOT NULL
- product_option — varchar(200) — NOT NULL
- cnt — int(11) — NOT NULL
- price — int(11) — NOT NULL
- regdate — datetime — NOT NULL
- userImage — varchar(255)
- userComment — text
bookmarker
- user_sn — varchar(255) — Primary key — NOT NULL
- bookmark_type — varchar(255) — Primary key — NOT NULL
- bookmark_sn — varchar(255) — Primary key — NOT NULL
calc_master
- id — int(11) — Primary key — NOT NULL
- calc_year — varchar(4) — NOT NULL
- calc_month — varchar(2) — NOT NULL
- calc_yn — varchar(1) — NOT NULL
- calc_count — int(11) — NOT NULL
- calc_date — datetime — NOT NULL
- total_supply — int(11) — NOT NULL
- total_vat — int(11) — NOT NULL
- total_tee — int(11) — NOT NULL
- total_pgtee — int(11) — NOT NULL
- total_etctee — int(11) — NOT NULL
- total_delay — int(11) — NOT NULL
- total_amt — int(11) — NOT NULL
- total_order_tee — int(11) — NOT NULL
calc_setting
- delay_rate — double
cancel_list
- idx — int(11) — Primary key — NOT NULL
- type — varchar(20) — NOT NULL
- orderidx — varchar(20) — NOT NULL
- cancelidx — int(11) — NOT NULL
- cancelcomment — text
- artist_sn — varchar(20) — NOT NULL
- cancelproc — varchar(20) — NOT NULL
- canceluserSN — varchar(20) — NOT NULL
- canceldate — datetime — NOT NULL
- processdate — datetime
cash_history
- id — int(11) — Primary key — NOT NULL
- user_sn — varchar(20) — NOT NULL
- cash_type — varchar(10) — NOT NULL
- title — varchar(255) — NOT NULL
- cash — int(11) — NOT NULL
- regdate — datetime — NOT NULL
- value1 — varchar(255)
cash_refund
- idx — int(11) — Primary key — NOT NULL
- userSN — varchar(20) — NOT NULL
- amt — int(11) — NOT NULL
- process — varchar(20) — NOT NULL
- requestdate — datetime — NOT NULL
- processdate — datetime
- comment — text
- bankname — varchar(100) — NOT NULL
- accNo — varchar(100) — NOT NULL
- accountName — varchar(100) — NOT NULL
category
- category_sn — varchar(255) — Primary key — NOT NULL
- category_name — varchar(255) — NOT NULL
- use_yn — varchar(1) — NOT NULL
- ord — int(255) — NOT NULL
- regdate — datetime — NOT NULL
- category_subname — varchar(255)
- category_en_name — varchar(255)
- category_en_subname — varchar(255)
- category_type — varchar(10)
- category_pic — varchar(255)
- category_jp_name — varchar(255)
- category_chi_name — varchar(255)
- category_jp_subname — varchar(255)
- category_chi_subname — varchar(255)
category_master
- idx — int(11) — Primary key — NOT NULL
- category_name — varchar(255) — NOT NULL
- category_en_name — varchar(255)
- category_jp_name — varchar(255)
- category_chi_name — varchar(255)
- category_pic — varchar(255) — NOT NULL
- sort — int(11) — NOT NULL
category_master_bak
- category_name — varchar(255) — Primary key — NOT NULL
- category_en_name — varchar(255)
- category_jp_name — varchar(255)
- category_chi_name — varchar(255)
- category_pic — varchar(255) — NOT NULL
- sort — int(11) — NOT NULL
comment
- id — int(11) — Primary key — NOT NULL
- order_sn — varchar(20) — NOT NULL
- ticket_sn — varchar(20)
- user_sn — varchar(20) — NOT NULL
- artist_sn — varchar(20) — NOT NULL
- comment_type — varchar(10) — NOT NULL
- comment — text — NOT NULL
- comment_pic1 — varchar(255)
- comment_pic2 — varchar(255)
- comment_pic3 — varchar(255)
- comment_pic4 — varchar(255)
- regdate — datetime — NOT NULL
- timestamp — int(11) — NOT NULL
- from_sn — varchar(20) — NOT NULL
- to_sn — varchar(20) — NOT NULL
- read_YN — varchar(1) — NOT NULL
common_code
- idx — int(11) — Primary key — NOT NULL
- codeType — varchar(20) — NOT NULL
- code — varchar(30) — NOT NULL
- codeName — varchar(200) — NOT NULL
- upcode — varchar(20)
- useYN — varchar(1) — NOT NULL
- value1 — varchar(255)
- value2 — varchar(255)
- value3 — varchar(255)
- value4 — varchar(255)
- value5 — varchar(255)
- memo — text
- regdate — datetime — NOT NULL
common_code_master
- codeType — varchar(20) — Primary key — NOT NULL
- codeTypeName — varchar(255) — NOT NULL
- regdate — datetime — NOT NULL
common_img
- img_name — varchar(255) — NOT NULL
- top_pic — varchar(4000) — NOT NULL
- bottom_pic — varchar(4000) — NOT NULL
contact
- contact_sn — int(11) — Primary key — NOT NULL
- contact_user_sn — varchar(12) — NOT NULL
- contact_content — text — NOT NULL
- contact_return — text
- contact_success — tinyint(4) — NOT NULL
- contact_time — datetime — NOT NULL
content
- id — int(11) — Primary key — NOT NULL
- type — varchar(255) — NOT NULL
- content — longtext — NOT NULL
coupon
- coupon_sn — varchar(255) — Primary key — NOT NULL
- coupon_type — varchar(255) — NOT NULL
- coupon_title — varchar(255) — NOT NULL
- coupon_discount — int(11)
- coupon_price — int(11)
- start_dt — datetime
- end_dt — datetime
- coupon_comment — varchar(255)
- regdate — datetime — NOT NULL
- coupon_en_title — varchar(255)
- coupon_en_comment — varchar(255)
- coupon_img — varchar(255)
- img_type — varchar(10)
- minamt — int(11)
- maxamt — int(11)
- publish_type — varchar(20) — NOT NULL
- artist_sn — varchar(20)
- use_type — varchar(10) — NOT NULL
- sales_type — varchar(10)
- salecount — int(11)
- coupon_proc — varchar(255) — NOT NULL
- coupon_refuse_reason — varchar(100)
coupon_code
- code — varchar(255) — Primary key — NOT NULL
- coupon_sn — varchar(255) — NOT NULL
- use_yn — varchar(1) — NOT NULL
- start_dt — datetime — NOT NULL
- end_dt — datetime — NOT NULL
- regdate — datetime — NOT NULL
- user_sn — varchar(20)
- active_yn — varchar(1) — NOT NULL
delivery
- company — varchar(20) — Primary key — NOT NULL
- url — varchar(255) — NOT NULL
event
- idx — int(255) — Primary key — NOT NULL
- event_sn — varchar(255) — NOT NULL
- event_title — varchar(255) — NOT NULL
- event_pic — varchar(255) — NOT NULL
- start_dt — datetime — NOT NULL
- end_dt — datetime — NOT NULL
- use_yn — varchar(1) — NOT NULL
- regdate — datetime — NOT NULL
goods
- goods_sn — varchar(12) — Primary key — NOT NULL — 상품 일련번호
- goods_name — varchar(255) — NOT NULL — 상품명
- goods_price — int(11) — NOT NULL — 상품 가격
- goods_category — varchar(255) — NOT NULL
- goods_en_name — varchar(255)
- goods_jp_name — varchar(255)
- goods_chi_name — varchar(255)
- open_yn — varchar(1) — NOT NULL
- goods_en_chk — varchar(10)
- goods_jp_chk — varchar(10)
- goods_chi_chk — varchar(10)
goods_option
- goods_option_sn — varchar(255) — Primary key — NOT NULL
- goods_sn — varchar(255) — NOT NULL
- goods_type — varchar(255) — NOT NULL
- option_img — varchar(255) — NOT NULL
- option_title — varchar(255) — NOT NULL
- option_subtitle — varchar(255) — NOT NULL
- use_yn — varchar(1) — NOT NULL
- regdate — datetime — NOT NULL
- option_lng — varchar(255) — NOT NULL
goods_option_back
- goods_option_sn — int(11) — Primary key — NOT NULL
- goods_sn — varchar(12) — NOT NULL
- goods_option_name — varchar(255) — NOT NULL
- goods_option_price — int(11) — NOT NULL
- artist_sn — varchar(12)
goods_order_item
- idx — int(11) — Primary key — NOT NULL
- order_sn — varchar(20) — NOT NULL
- product_sn — varchar(20) — NOT NULL
- product_option — varchar(200) — NOT NULL
- cnt — int(11) — NOT NULL
- regdate — datetime — NOT NULL
- calc_YN — varchar(1) — NOT NULL
- delivery_company — varchar(20) — NOT NULL
- delivery_no — varchar(100) — NOT NULL
- order_status — varchar(10) — NOT NULL
- userImage — varchar(100) — NOT NULL
- userComment — varchar(200) — NOT NULL
goods_order_master
- order_sn — varchar(20) — Primary key — NOT NULL
- user_sn — varchar(20) — NOT NULL
- price — int(11) — NOT NULL
- point — int(11) — NOT NULL
- cash — int(11) — NOT NULL
- discount — int(11) — NOT NULL
- savepoint — int(11) — NOT NULL
- delivery_price — int(11) — NOT NULL
- delivery_name — varchar(20) — NOT NULL
- delivery_postno — varchar(10) — NOT NULL
- delivery_addr1 — varchar(200) — NOT NULL
- delivery_addr2 — varchar(200) — NOT NULL
- delivery_phone — varchar(20) — NOT NULL
- delivery_email — varchar(100) — NOT NULL
- request_comment — varchar(2000) — NOT NULL
- coupon — varchar(20) — NOT NULL
- regdate — datetime — NOT NULL
- modifydate — datetime — NOT NULL
goods_port
- goods_port_sn — int(11) — Primary key — NOT NULL — 상품 사진 번호
- goods_sn — varchar(12) — NOT NULL — 상품 일련번호
- goods_port — varchar(255) — NOT NULL — 상품 사진 경로
goods_review
- review_idx — int(255) — Primary key — NOT NULL
- product_sn — varchar(255) — NOT NULL
- review_star — double(22,0) — NOT NULL
- userID — varchar(255) — NOT NULL
- review_comment — varchar(4000) — NOT NULL
- review_pic — varchar(4000) — NOT NULL
- write_comment — varchar(4000)
- regdate — datetime — NOT NULL
- write_regdate — datetime
- quality — int(11) — NOT NULL
- kindness — int(11) — NOT NULL
- meticulous — int(11) — NOT NULL
- reception — int(11) — NOT NULL
- working — int(11) — NOT NULL
- order_sn — varchar(20) — NOT NULL
- status — varchar(1)
- useYN — varchar(1) — NOT NULL
goods_review_bak
- review_idx — int(255) — Primary key — NOT NULL
- goods_sn — varchar(255) — NOT NULL
- review_star — double(22,0) — NOT NULL
- userid — varchar(255) — NOT NULL
- review_comment — varchar(4000) — NOT NULL
- review_pic — varchar(255) — NOT NULL
- write_comment — varchar(4000) — NOT NULL
- regdate — datetime — NOT NULL
- write_regdate — datetime — NOT NULL
goods_sub_option
- goods_option_sn — varchar(255) — Primary key — NOT NULL
- option_seq — int(255) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- price — int(255) — NOT NULL
- regdate — datetime — NOT NULL
- option_type — varchar(10)
- use_yn — varchar(1)
- price_type — varchar(255) — NOT NULL