dblab
Tables (7)
comment (댓글)
- comment_id (comment id) — LONG — Primary key — NOT NULL
- notice_id (notice id) — LONG — Foreign key → notice.notice_id — NOT NULL
- user_id (댓글 작성자) — LONG — Foreign key → user.user_id — NOT NULL
- contents (내용) — TEXT
like (좋아요)
- like_id (like id) — LONG — Primary key — NOT NULL
- notice_id (notice id) — LONG — Foreign key → notice.notice_id — NOT NULL
- user_id (좋아요한 사람) — LONG — Foreign key → user.user_id — NOT NULL
member (멤버)
- member_id (member id) — LONG — Primary key — NOT NULL
- name (이름) — VARCHAR(255)
- year (학번) — INT
- detail (상세) — VARCHAR(255)
- profile_img (프로필 이미지) — VARCHAR(255)
- status (상태) — ENUM
notice (공지사항)
- notice_id (notice id) — LONG — Primary key — NOT NULL
- user_id (작성자) — LONG — Foreign key → user.user_id — NOT NULL
- title (제목) — VARCHAR(255)
- content (내용) — TEXT
- createdAt (생성일시) — DATETIME
- updatedAt (수정일시) — DATETIME
notice_image (공지사항 이미지)
- img_id (notice_img_id) — LONG — Primary key — NOT NULL
- notice_id (notice id) — LONG — Foreign key → notice.notice_id — NOT NULL
- img_url (image url) — VARCHAR(255)
project (프로젝트)
- project_id (project id) — LONG — Primary key — NOT NULL
- userId (사용자 ID) — LONG — Foreign key → user.user_id — NOT NULL
- title (제목) — VARCHAR(255)
- content (내용) — TEXT
- period (진행기간) — VARCHAR(255)
- createdAt (생성일시) — DATETIME
- updatedAt (수정일시) — DATETIME
user (사용자)
- user_id (사용자 ID) — LONG — Primary key — NOT NULL
- email (이메일) — varchar(255)
- password (패스워드) — VARCHAR(255)
- name (이름) — VARCHAR(45)
- role (역할) — ENUM
- phone (전화번호) — VARCHAR(45)
- profile_img (프로필 이미지) — VARCHAR(255)
- github (깃허브 주소) — VARCHAR(255)
- category (카테고리(공부분야)) — ENUM