wblog

Tables (5)

TB_POINT_COMMISSION (Untitled2)

  • commission_id (Key) — Primary key — NOT NULL
  • recommender_id (Field)
  • referred_user_id (Field2)
  • orginal_amount (Field3)
  • commission_amount (Field4)
  • created_at (Field5)

TB_POINT_HISTORY (Untitled4)

  • history_id (Key) — Primary key — NOT NULL
  • user_id (Field)
  • amount (Field2)
  • type (Field3)
  • descripption (Field4)
  • created_at (Field5)

TB_POINT_WALLET (Untitled)

  • wallet_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → TB_USER.user_id — NOT NULL
  • user_id (Field)
  • point_balance (Field2)

TB_POST_LOG (Untitled3)

  • post_job_id (Key) — Primary key — NOT NULL
  • user_id (Field)
  • blog_account_id (Field2)
  • use_point (Field3)
  • created_at (Field4)

TB_USER

  • user_id (Key) — Primary key — NOT NULL
  • user_nm (Field)
  • password (Field2)
  • email (Field3)
  • birth_day (Field4)
  • phone_number (Field5)
  • use_yn (Field6)
  • recommender_id (Field7)
  • cre_dt (Field8)
  • cre_id (Field9)
  • upd_dt (Field10)
  • upd_id (Field11)