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