StudyLog

Tables (10)

Board (게시판)

  • b_id (게시판아이디) — LONG — Primary key — NOT NULL
  • category (게시판대분류) — VARCHAR

ChatLog (채팅로그)

  • c_log_id (채팅로그아이디) — LONG — Primary key — NOT NULL
  • chat_room_id (채팅방아이디) — LONG
  • sender_id (보낸사람아이디) — LONG
  • message (메시지내용) — VARCHAR
  • sent_at (전송시간) — TIMESTAMP

ChatRoom (채팅방)

  • c_room_id (채팅방아이디) — LONG — Primary key — NOT NULL
  • group_id (그룹아이디) — LONG

Comment (댓글)

  • c_id (댓글아이디) — LONG — Primary key — NOT NULL
  • post_id (게시글아이디) — LONG
  • author_id (작성자아이디) — LONG
  • content (댓글내용) — VARCHAR
  • created_at (작성일지) — TIMESTAMP

Group (그룹)

  • g_room_id (그룹아이디) — LONG — Primary key — NOT NULL
  • g_name (그룹이름) — VARCHAR
  • g_description (그룹설명) — VARCHAR

GroupMember (그룹멤버)

  • gm_id (그룹멤버아이디) — LONG — Primary key — NOT NULL
  • user_id (유저아이디) — LONG
  • group_id (그룹아이디) — LONG

Post (게시글)

  • p_id (게시글아이디) — LONG — Primary key — NOT NULL
  • board_id (게시판아이디) — LONG
  • author_id (작성자아이디) — LONG
  • title (게시글제목) — VARCHAR
  • content (게시글본문) — VARCHAR
  • b_notice (게시글공지여부) — BOOLEAN
  • created_at (작성일지) — TIMESTAMP

PostTag (게시글-태그 매핑)

  • pt_id (매핑아이디) — LONG — Primary key — NOT NULL
  • post_id (게시글아이디) — LONG
  • tag_id (태그아이디) — LONG

Tag (태그)

  • t_id (태그아이디) — LONG — Primary key — NOT NULL
  • name (태그이름) — VARCHAR

User (유저)

  • u_id (유저아이디) — LONG — Primary key — NOT NULL
  • u_name (유저이름) — VARCHAR
  • u_password (유저비밀번호) — VARCHAR
  • u_email (유저이메일) — VARCHAR
  • u_role (유저권한) — VARCHAR