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