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