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