group

Tables (7)

Chating Message (Untitled6)

  • chat _id (chat_id) — INT — Primary key — NOT NULL
  • group_id — INT
  • groupcretate_id (create_id) — INT
  • message_content — TEXT
  • sent_at (sent_time) — TIMESTAMP
  • Field

Comment (Untitled5)

  • Comment_id (comment_id) — INT — Primary key — NOT NULL
  • post_id — INT
  • user_id — INT
  • content — TEXT
  • created_at (created) — TIMESTAMP

Event (Untitled3)

  • event_num (event_number) — INT — Primary key — NOT NULL
  • group_id — INT
  • titlet (title) — VARCHAR(100)
  • description — TEXT
  • event_date (date) — TIMESTAMP
  • created_At (created) — TIMESTAMP

Group (Untitled)

  • group_id (id) — INT — Primary key — NOT NULL
  • representation id (representation_id) — INT — Foreign key → Group_member.representation id — NOT NULL
  • post_id — INT — Foreign key → Post.post_id — NOT NULL
  • Comment_id (comment_id) — INT — Foreign key → Post.Comment_id — NOT NULL
  • event_num (event_number) — INT — Foreign key → Event.event_num — NOT NULL
  • chat _id (chat_id) — INT — Foreign key → Chating Message.chat _id — NOT NULL
  • groupname (name) — VARCHAR(100)
  • groupDescription (description) — TEXT
  • groupCategory (category) — VARCHAR(50)
  • groupLocation (location) — VARCHAR(50)
  • groupImage (image) — TEXT
  • groupcreate_id (create_id) — INT
  • groupcreate_at (create_day) — TIMESTAMP
  • groupdeadline (deadline) — TIMESTAMP
  • groupday (d-day) — TIMESTAMP

Group_member (Untitled2)

  • representation id (representation_id) — INT — Primary key — NOT NULL
  • user_id — INT
  • group_id (groupid) — INT
  • joined_at (joined) — TIMESTAMP

Post (Untitled4)

  • post_id — INT — Primary key — NOT NULL
  • Comment_id (comment_id) — INT — Foreign key → Comment.Comment_id — NOT NULL
  • group_id — INT
  • user_id — INT
  • title — VARCHAR(100)
  • content — TEXT
  • created_at (created) — TIMESTAMP

User (커뮤니티)

  • user ID (id) — INT — Primary key — NOT NULL
  • group_id (id2) — INT — Foreign key → Group.group_id — NOT NULL
  • representation id (representation_id) — INT — Foreign key → Group_member.representation id — NOT NULL
  • representation id (representation_id2) — INT — Foreign key → Group.representation id — NOT NULL
  • post_id — INT — Foreign key → Post.post_id — NOT NULL
  • post_id (post_id2) — INT — Foreign key → Group.post_id — NOT NULL
  • Comment_id (comment_id) — INT — Foreign key → Comment.Comment_id — NOT NULL
  • Comment_id (comment_id2) — INT — Foreign key → Post.Comment_id — NOT NULL
  • event_num (event_number) — INT — Foreign key → Group.event_num — NOT NULL
  • chat _id (chat_id) — INT — Foreign key → Group.chat _id — NOT NULL
  • chat _id (chat_id2) — INT — Foreign key → Chating Message.chat _id — NOT NULL
  • username — VARCHAR(20)
  • password — VARCHAR(20) UNIQUE
  • email — VARCHAR(255)
  • profile_image — TEXT
  • created_at — TIMESTAMP
  • group_id — INT