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)