STUDY
Tables (10)
Board
- b_id — BIGINT
- b_name — VARCHAR(255) — NOT NULL
- description — VARCHAR(255) — NOT NULL
ChatLog
- c_log_id — BIGINT — Primary key
- chat_room_id — BIGINT — NOT NULL
- sender_id — BIGINT — NOT NULL
- message — TEXT — NOT NULL
- sent_at — TIMESTAMP — NOT NULL
ChatRoom
- c_room_id — BIGINT — Primary key
- group_id — BIGINT — NOT NULL
Comment
- c_id — BIGINT — Primary key
- post_id — BIGINT — NOT NULL
- author_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
Group
- g_room_id — BIGINT — Primary key
- g_name — VARCHAR(255) — NOT NULL
- g_description — VARCHAR(255) — NOT NULL
GroupMember
- gm_id — BIGINT — Primary key
- user_id — BIGINT — NOT NULL
- group_id — BIGINT — NOT NULL
Post
- p_id — BIGINT — Primary key
- board_id — BIGINT — NOT NULL
- author_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- b_notice — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
PostTag
- pt_id — BIGINT — Primary key
- post_id — BIGINT — NOT NULL
- tag_id — BIGINT — NOT NULL
Tag
- t_id — BIGINT — Primary key
- name — VARCHAR(100) — NOT NULL
User
- u_id — BIGINT — Primary key
- u_name — VARCHAR(255) — NOT NULL
- u_password — VARCHAR(255) — NOT NULL
- u_email — VARCHAR(255) — NOT NULL
- u_role — VARCHAR(50) — NOT NULL