eh

Tables (5)

comment (tbl_comment)

  • id (Key) — Primary key — NOT NULL
  • content (Field)
  • post_id (Key2) — Foreign key → post.id — NOT NULL
  • writer_id (Key3) — Foreign key → user.id — NOT NULL

group (tbl_group)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • profile_image (Field2)
  • background_image (Field3)
  • description (Field4)
  • poster_image (Field5)
  • max_people (Field6)
  • set_time (Field7)
  • owner_id (Key2) — Foreign key → user.id — NOT NULL

post (tbl_post)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • is_promotion (Field3)
  • created_at (Field4)
  • wrtier_id (key2) — Foreign key → user.id — NOT NULL
  • group_id (Key2) — Foreign key → group.id — NOT NULL

user (tbk_user)

  • id (Key) — Primary key — NOT NULL
  • email (Field)
  • password (Field2)
  • nickname (Field3)
  • description (Field4)
  • porifle_image_url (Field5)

user_group (tbl_user)

  • group_id (Key3) — Foreign key → group.id — NOT NULL
  • user_id (Key4) — Foreign key → user.id — NOT NULL
  • intro (Field2)
  • member (Field)