study

Tables (13)

Calendar

  • id — bingint — Primary key — NOT NULL
  • user_id — bingint — Foreign key → Users.id — NOT NULL
  • start_date — DAYTIME
  • end_date — DATATIME
  • content — varchar(100)
  • created_at — DAYTIME

ChatBot

  • id — bigint — Primary key — NOT NULL
  • user_id — bingint — Foreign key → Users.id — NOT NULL
  • title — varchar(255)
  • created_at — DAYTIME

ChatBotmessage

  • id — bigint — Primary key — NOT NULL
  • session_id — bigint — Foreign key → ChatBot.id — NOT NULL
  • user_id — bingint — Foreign key → ChatBot.user_id — NOT NULL
  • sender_type — enum
  • message — varchar(255)
  • created_at — DAYTIME

ChatMessages

  • id — bigint — Primary key — NOT NULL
  • chatroom_id — bigint — Foreign key → ChatRoomUsers.chatroom_id — NOT NULL
  • user_id — bingint — Foreign key → Users.id — NOT NULL
  • created_at — DAYTIME
  • is_read — BOOLEAN
  • message — varchar(255)

ChatRoomUsers

  • id — bigint — Primary key — NOT NULL
  • chatroom_id — bigint — Foreign key → Chatrooms.id — NOT NULL
  • user_id — bigint — Foreign key → Users.id — NOT NULL
  • created_at — DAYTIME

Chatrooms

  • id — bigint — Primary key — NOT NULL
  • room_name — varchat(20)
  • created_at — DAYTIME

Comments

  • id — bigint — Primary key — NOT NULL
  • post_id — bigint — Foreign key → Posts.id — NOT NULL
  • user_id2 — bigint — Foreign key → Posts.user_id — NOT NULL
  • content — varchar(500)
  • created_at — DAYTIME
  • Field — VARCHAR(255)

Posts

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → Users.id — NOT NULL
  • title — varchar(100)
  • content — varchar(500)
  • count — bigint
  • rating — float
  • created_at — DATETIME

ProductReviews

  • id — bigint — Primary key — NOT NULL
  • product_id — bingint — Foreign key → Users.id — NOT NULL
  • user_id — bigint — Foreign key → Shop.id — NOT NULL
  • rating — float
  • title — varchar(500)
  • content — varchar(500)
  • created_at — VARCHAR(255)

ProductTag

  • id — bigint — Primary key — NOT NULL
  • product_id — bigint — Foreign key → Shop.id — NOT NULL
  • tag_name — varchar(300)

Shop

  • id — bigint — Primary key — NOT NULL
  • item_title — varchar(20)
  • price — bigintt
  • item_url — varchaar(255)
  • created_at — DAYTIME
  • content — varchar(500)
  • tag_name — VARCHAR(255)
  • Field — VARCHAR(255)

Untitled

    Users

    • id — bingint — Primary key — NOT NULL
    • name — varchar(10)
    • email — varchar(50)
    • log_id — varchar(30)
    • pwd_hash — varchar(255)
    • profile_img — varchar(255)
    • created_at — DAYTIME
    • Field — VARCHAR(255)