Relay
Tables (20)
BRAND (Untitled18)
- brand_id (Key) — char(2) — Primary key — NOT NULL
- brand_domain (Field) — varchar(20) — NOT NULL
- brand_name (Field2) — varchar(50) — NOT NULL
- st_code (Field3) — char(2) — NOT NULL
- cr_date (Field4) — datetime — NOT NULL
- up_date (Field5) — datetime — NOT NULL
- mo_user (Field6) — varchar(20)
- note (Field7) — varchar(200)
PROD (Untitled11)
- prod_id (Key) — int(11) — Primary key — NOT NULL
- brand_id (Key2) — char(2) — Foreign key → BRAND.brand_id — NOT NULL
- status (Field) — char(2) — NOT NULL
- src_group (Field2) — char(1) — NOT NULL
- src_spec (Field3) — char(2) — NOT NULL
- brand_id (Field4) — char(2) — NOT NULL
- brand_sub_id (Field5) — char(2) — NOT NULL
- sn_code (Field6) — varchar(50) — NOT NULL
- cls1_code (Field7) — char(2)
- cls2_code (Field8) — char(2)
- sell_flag (Field9) — char(1)
- disp_flag (Field10) — char(1) — NOT NULL
- sold_out_flag (Field11) — char(1) — NOT NULL
- img_link_th (Field12) — varchar(1000) — NOT NULL
- img_link_th2 (Field13) — varchar(1000)
- name (Field14) — varchar(250) — NOT NULL
- detail_desc (Field15) — blob
- detail_clean (Field16) — blob
- detail_info (Field17) — blob
- detail_size (Field18) — blob
- price_org (Field19) — int(10) — NOT NULL
- season (Field20) — char(1) — NOT NULL
- season_idx (Field21) — tinyint(3) — NOT NULL
- year_org (Field22) — varchar(10) — NOT NULL
- disp_date (Field23) — datetime
- st_code (Field24) — char(2) — NOT NULL
- cr_date (Field25) — datetime — NOT NULL
- up_date (Field26) — datetime — NOT NULL
- mo_user (Field27) — varchar(20) — NOT NULL
- note (Field28) — varchar(500)
USER (tb_user)
- user_id — int(11) — Primary key — NOT NULL
- user_class — char(2) — NOT NULL
- user_pdate — datetime
- sns_type — char(5) — NOT NULL
- relay_id (Field3) — varchar(50) — NOT NULL
- relay_pw (Field4) — varchar(100) — NOT NULL
- brand_id (Field5) — char(2) — NOT NULL
- nick (Field6) — varchar(50) — NOT NULL
- img_link (Field7) — varchar(1000)
- img_link_th (Field8) — varchar(1000)
- ma_flag (Field9) — char(1) — NOT NULL
- auth_flag (Field) — char(1) — NOT NULL
- buid_auth_flag (Field2) — char(1) — NOT NULL
- buid (Field10) — varchar(100)
- st_code (Field11) — char(2) — NOT NULL
- cr_date (Field12) — datetime — NOT NULL
- up_date (Field13) — datetime — NOT NULL
- mo_user (Field14) — varchar(20)
- note (Field15) — varchar(400)
USER_ADDR_RECV (Untitled2)
- addr_id (Key) — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → USER.user_id — NOT NULL
- default_flag (Field2) — char(1) — NOT NULL
- recv_name (Field3) — varchar(100) — NOT NULL
- addr_code (Field4) — char(5) — NOT NULL
- addr0 (Field5) — varchar(200) — NOT NULL
- addr1 (Field6) — varchar(200) — NOT NULL
- tel_no (Field7) — varchar(100) — NOT NULL
- msg (Field8) — varchar(100) — NOT NULL
- cr_date (Field9) — datetime — NOT NULL
USER_ADDR_SEND (Untitled3)
- user_id (user_id2) — int(11) — Foreign key → USER.user_id — NOT NULL
- addr_code (Field) — char(5) — NOT NULL
- addr0 (Field2) — varchar(200) — NOT NULL
- addr1 (Field3) — varchar(200) — NOT NULL
- up_date (Field4) — datetime — NOT NULL
USER_AUTH (Untitled)
- user_id — int(11) — Foreign key → USER.user_id — NOT NULL
- name (Field) — varchar(200) — NOT NULL
- phone (Field2) — varchar(200) — NOT NULL
- gender (Field3) — varchar(10) — NOT NULL
- birthday (Field4) — char(10) — NOT NULL
- unique_key (Field5) — varchar(200) — NOT NULL
- unique_in_site (Field6) — varchar(200) — NOT NULL
- cr_date (Field7) — datetime — NOT NULL
USER_CART (Untitled4)
- idx (Key) — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → USER.user_id — NOT NULL
- prod_id (Key2) — int(11) — Foreign key → PROD.prod_id — NOT NULL
- cr_date (Field) — datetime — NOT NULL
USER_CREDIT (Untitled5)
- idx (Key) — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → USER.user_id — NOT NULL
- brand_id (Field) — char(2) — NOT NULL
- item_id (Field2) — int(10)
- sn_code (Field3) — varchar(20)
- sell_code (Field4) — char(8) — NOT NULL
- mark (Field5) — char(1) — NOT NULL
- credit (Field6) — int(10) — NOT NULL
- req_result (Field7) — varchar(200) — NOT NULL
- res_data (Field8) — varchar(1000)
- ipu_id (Field9) — int(10) — NOT NULL
- st_code (Field10) — char(2) — NOT NULL
- cr_date (Field11) — datetime — NOT NULL
- mo_user (Field12) — varchar(20) — NOT NULL
- note (Field13) — varchar(200)
USER_CS (Untitled6)
- ucs_id (Key) — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → USER.user_id — NOT NULL
- status (Field) — char(2) — NOT NULL
- title (Field2) — varchar(200)
- mo_user (Field3) — varchar(20) — NOT NULL
- cr_date (Field4) — datetiem — NOT NULL
USER_CS_ITEM (Untitled7)
- idx (Key) — int(11) — Primary key — NOT NULL
- ucs_id (Key2) — int(11) — Foreign key → USER_CS.ucs_id — NOT NULL
- msg (Field2) — varchar(1000)
- mo_user (Field3) — varchar(20) — NOT NULL
- cr_date (Field4) — datetime — NOT NULL
USER_DROP (Untitled8)
- user_id — int(11) — Foreign key → USER.user_id — NOT NULL
- sns_type (Field) — char(5) — NOT NULL
- relay_id (Field2) — varchar(50) — NOT NULL
- brand_id (Field3) — char(2) — NOT NULL
- gender (Field4) — varchar(10)
- birthday (Field5) — char(10)
- cr_date (Field6) — datetime — NOT NULL
USER_FREERET (Untitled9)
- idx (Key) — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → USER.user_id — NOT NULL
- msg (Field) — varchar(100) — NOT NULL
- cnt (Field2) — tinyint(3) — NOT NULL
- remain (Field3) — tinyint(3) — NOT NULL
- st_code (Field4) — char(2) — NOT NULL — ok, od
- cr_date (Field5) — datetime — NOT NULL
- up_date (Field6) — datetime — NOT NULL
- mo_user (Field7) — varchar(20)
- note (Field8) — varchar(200)
USER_HEARTP (Untitled10)
- idx (Key) — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → USER.user_id — NOT NULL
- prod_id (Key2) — int(11) — Foreign key → PROD.prod_id — NOT NULL
- cr_date (Field) — datetime — NOT NULL
USER_NAME (Untitled12)
- user_id — int(11) — Foreign key → USER.user_id — NOT NULL
- name (Field) — varchar(50) — NOT NULL
- up_date (Field2) — datetime — NOT NULL
USER_PHONE (CopyOfUntitled12)
- user_id — int(11) — Foreign key → USER.user_id — NOT NULL
- phone (Field) — varchar(20) — NOT NULL
- up_date (Field2) — datetime — NOT NULL
USER_POINT (Untitled13)
- up_id (Key) — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → USER.user_id — NOT NULL
- point_type (Field) — char(1) — NOT NULL
- point_msg (Field2) — varchar(100) — NOT NULL
- point_value (Field3) — int(11) — NOT NULL
- point_tot (Field4) — int(10) — NOT NULL
- sales_id (Field5) — int(10)
- st_code (Field6) — char(2) — NOT NULL — ok, od
- cr_date (Field7) — datetime — NOT NULL
- up_date (Field8) — datetime — NOT NULL
- mo_user (Field9) — varchar(20)
- note (Field10) — varchar(200)
USER_REFUND (Untitled14)
- user_id — int(11) — Foreign key → USER.user_id — NOT NULL
- bank_name (Field) — varchar(50) — NOT NULL
- bank_account (Field2) — varchar(20) — NOT NULL
- bank_holder (Field3) — varchar(100) — NOT NULL
- up_date (Field4) — datetime — NOT NULL
USER_SESSION (Untitled15)
- user_id — int(11) — Foreign key → USER.user_id — NOT NULL
- atoken (Field) — varchar(500) — NOT NULL
- rtoken (Field2) — varchar(500) — NOT NULL
- up_date (Field3) — datetime — NOT NULL
USER_TMP (Untitled16)
- user_tmp_id (Key) — int(11) — Primary key — NOT NULL
- ma_flag (Field) — char(1) — NOT NULL
- name (Field2) — varchar(100) — NOT NULL
- phone (Field3) — varchar(100) — NOT NULL
- gender (Field4) — varchar(10) — NOT NULL
- birthday (Field5) — char(10) — NOT NULL
- unique_key (Field6) — varchar(200) — NOT NULL
- unique_in_site (Field7) — varchar(200) — NOT NULL
- st_code (Field8) — char(2) — NOT NULL
- cr_date (Field9) — datetime — NOT NULL
USER_TMP_INFO (Untitled17)
- idx (Key) — int(11) — Primary key — NOT NULL
- user_id (Field2) — int(10) — NOT NULL
- brand_id (Field) — char(2)
- name (Field3) — varchar(20)
- phone (Field4) — varchar(20)
- ma_flag (Field5) — char(1)
- cr_date (Field6) — datetime