onedayoneclass

Tables (11)

cart (Untitled2)

  • cart_id (Long)
  • user_id (Field2)
  • lecture_id (Field3)

chat_message (Untitled5)

  • msg_id (Field)
  • room_id (Field2)
  • sender_id (BIGINT)
  • sender_role (enum)
  • message (Field3)
  • msg_type (Field4)
  • created_at (Field5)

chat_room (Untitled4)

  • room_id (BigInt)
  • user_id (Field)
  • agent_id (Field2)
  • created_at (Field3)
  • Field4

coupon (Untitled8)

  • coupon_id (Field)
  • code (Field2)
  • name (Field3)
  • discount_type (Field4)
  • discount_val (Field5)
  • min_order_amt (Field6)
  • valid_from (Field7)
  • valid_to (Field8)
  • Field9

lecture (Untitled)

  • lecture_id (Auto) — Primary key — NOT NULL
  • lecturename (Varchar)
  • likes (Field2)
  • comments (Field)
  • thunbnail (Field4)
  • studentNum (Field5)
  • description (Field3)
  • teacherName (Field6)
  • content (Field7)
  • category (Field8)

lecture_comment (Untitled6)

  • comment_id (Field)
  • lecture_id (Field2)
  • user_id (Field3)
  • content (Field4)
  • created_at (Field5)
  • parent_id (Field6)

message (Untitled10)

  • msg_id (Field)
  • sender_id (Field2)
  • receiver_id (Field3)
  • is_read (Field4) — Boolean
  • sent_at (Field5)
  • content (Field6)

teacher (Untitled7)

  • teacher_id (Field)
  • teacher_name (Field2)
  • profile_img (Field3)
  • gender (Field4)
  • lecture (Field5)
  • description (Field6)
  • bank_name (Field7)
  • bank_account (Field8)
  • created_at (Field9)
  • intro (Field10)
  • career (Field11)

teacher_board (Untitled11)

  • board_id (Field)
  • title (Field2)
  • content (Field3)
  • writer_id (Field4)
  • created_at (Field5)
  • view_count (Field6)

user (Untitled3)

  • user_id (Field)
  • username (Field2)
  • password (Field3)
  • email (Field4)
  • created_at (Field5)
  • address (Field6)
  • role (Field7)
  • status (Field8)
  • phone (Field9)
  • emailRecieveAgree (Field10)
  • coupon (Field11)
  • point (Field12)
  • gender (Field13)
  • lastest_login_at (Field14)

user_coupon (Untitled9)

  • user_coupon_id (Field)
  • user_id (Field2)
  • coupon_id (Field3)