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