lulu

Tables (24)

baseEntity (Untitled9)

  • enabled (Field4)
  • created_at (Field)
  • last_updated_at (Field5)

chat_board (Untitled11)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • title (Field)
  • content (Field6)
  • hit_count (Field2)
  • is_notice (Field3)
  • is_hot (Field4)
  • category (Field5)

chat_board_bookmark (Untitled22)

  • id (Key) — Primary key — NOT NULL
  • chat_board_id (Key2) — Foreign key → chat_board.id — NOT NULL
  • user_id (Key3) — Foreign key → user.id — NOT NULL

chat_board_category (Untitled19)

  • id (Key) — Primary key — NOT NULL
  • title (Field)

chat_board_category_set (Untitled20)

  • id (Key) — Primary key — NOT NULL
  • chat_board_id (Key2) — Foreign key → chat_board.id — NOT NULL
  • chat_board_category_id (Key3) — Foreign key → chat_board_category.id — NOT NULL

chat_board_comment (Untitled21)

  • id (Key2) — Primary key — NOT NULL
  • chat_board_id (Key) — Foreign key → chat_board.id — NOT NULL
  • parent_id (Field)
  • content (Field2)

chat_board_like (Untitled23)

  • id (Key3) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • chat_board_id (Key) — Foreign key → chat_board.id — NOT NULL

event (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field5)
  • image (Field6)
  • enabled (Field4)
  • start_at (Field2)
  • end_at (Field3)
  • Field7
  • Field8
  • Field9

event_ participant (Untitled28)

  • id (Key) — Primary key — NOT NULL
  • event_id (Key2) — Foreign key → event.id — NOT NULL
  • user_id (Key3) — Foreign key → user.id — NOT NULL

event_comment (Untitled25)

  • id (Key) — Primary key — NOT NULL
  • event_id (Key2) — Foreign key → event.id — NOT NULL
  • parent_id (Field)
  • content (Field2)

info_ board_post (Untitled12)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • title (Field)
  • content (Field2)
  • view_count (Field4)

info_board_bookmark (Untitled18)

  • id (Key2) — Primary key — NOT NULL
  • user_id (Key) — Foreign key → user.id — NOT NULL
  • post_id (Key3) — Foreign key → info_ board_post.id — NOT NULL

info_board_comment (Untitled16)

  • id (Key2) — Primary key — NOT NULL
  • post_id (Key) — Foreign key → info_ board_post.id — NOT NULL
  • user_id (Key3) — Foreign key → user.id — NOT NULL
  • parent_id (Field)
  • content (Field2)

info_board_image (Untitled2)

  • id (Key2) — Primary key — NOT NULL
  • post_id (Key) — Foreign key → info_ board_post.id — NOT NULL
  • image (Field)

info_board_like (Untitled15)

  • id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → info_ board_post.id — NOT NULL
  • user_id (Key3) — Foreign key → user.id — NOT NULL

info_board_tag (Untitled14)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • is_hot (Field2)

info_board_tag_set (Untitled13)

  • id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → info_ board_post.id — NOT NULL
  • tag_id (Key3) — Foreign key → info_board_tag.id — NOT NULL

mother_class (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • title (Field)
  • content (Field2)
  • image (Field3)

mother_class_bookmark (Untitled17)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • mother_class_id (Key3) — Foreign key → mother_class.id — NOT NULL

mother_class_comment (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • mothehr_class_id (Key2) — Foreign key → mother_class.id — NOT NULL
  • user_id (Key3) — Foreign key → user.id — NOT NULL
  • comment (Field2)

mother_class_like (Untitled10)

  • id (Key3) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • mother_class_id (Key) — Foreign key → mother_class.id — NOT NULL

mother_class_tag (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • name (Field)

mother_class_tag_set (Untitled5)

  • id (Key3) — Primary key — NOT NULL
  • mother_class_id (Key) — Foreign key → mother_class.id — NOT NULL
  • mother_class_tag_id (Key2) — Foreign key → mother_class_tag.id — NOT NULL
  • id (Key22) — Foreign key → mother_class.user_id — NOT NULL

user (Untitled)

  • id (Key) — Primary key — NOT NULL
  • userid (Field3)
  • password (Field4)
  • name (Field)
  • nickname (Field5)
  • phone (Field2)
  • email (Field6)
  • gender (Field7)
  • birthday (Field9)
  • is_active (Field12)
  • picture (Field10)
  • lastPasswordChanged (Field11)