pwith_db

Tables (12)

bookContents (Untitled6)

  • Key (책 번호) — int — Primary key — NOT NULL

chat (Untitled10)

  • Key (채팅번호) — int — Primary key — NOT NULL
  • Field (보내는사람) — varchar(10) — member.memId
  • Field2 (받는사람) — varchar(10)
  • Field3 (내용) — varchar(500)
  • Field4 (작성날짜) — datetime
  • PK (아이디) — varchar(10) — Foreign key → member.PK — NOT NULL

it_news (Untitled5)

  • PK (뉴스번호) — int — Primary key — NOT NULL

lectureContents (Untitled7)

  • Key (강의번호) — int — Primary key — NOT NULL

liked (Untitled12)

  • PK (식별자) — int — Primary key — NOT NULL
  • Field (멤버Id) — varchar(10)
  • Field2 (게시글ID) — int
  • Field3 (좋아요 여부) — boolean
  • PK (아이디) — varchar(10) — Foreign key → member.PK — NOT NULL
  • Key (게시글번호) — int — Foreign key → post.Key — NOT NULL
  • PK (스터디룸 번호) — int — Foreign key → post.PK — NOT NULL
  • PK (아이디2) — varchar(10) — Foreign key → post.PK — NOT NULL

member (Untitled)

  • PK (아이디) — varchar(10) — Primary key — NOT NULL
  • (비밀번호) — varchar(20)
  • Field2 (이름) — varchar(10)
  • Field3 (이메일) — varchar(20)
  • Field4 (멘토여부) — boolean — NOT NULL
  • Field5 (가입한 스터디 목록) — json — NOT NULL — post.postType = 0 and postId 로 이루어진 배열

mento (Untitled8)

  • PK (멘토번호) — int — Primary key — NOT NULL
  • Field (멘티목록) — varchar(100)
  • Field2 (주제) — varchar(100)
  • Field3 (프로필이미지) — longblob
  • Field4 (내용) — varchar(500)
  • Field5 (작성날짜) — datetime
  • PK (아이디) — varchar(10) — Foreign key → member.PK — NOT NULL

mentoringRoom (Untitled11)

  • PK (방 번호) — int — Primary key — NOT NULL
  • PK (멘토번호) — int — Foreign key → mento.PK — NOT NULL
  • Field (방 이름) — varchar(20)
  • Field2 (멘토 ID) — int
  • Field3 (멘티 ID) — varchar(10)

post (Untitled2)

  • Key (게시글번호) — int — Primary key — NOT NULL
  • PK (스터디룸 번호) — int — Foreign key → studyRoom.PK — NOT NULL
  • PK (아이디) — varchar(10) — Foreign key → studyRoom.PK — NOT NULL
  • (게시글타입) — int — 0: study 1: QNA
  • Field2 (제목) — varchar(50)
  • Field4 (작성자) — varchar(10) — member.memId
  • Field5 (작성날짜) — datetime
  • Field6 (내용) — varchar(500)
  • Field7 (카테고리) — int — 미리 정해진 카테고리 0~10 중 1개
  • Field8 (좋아요 갯수) — int
  • Field9 (좋아요 여부) — boolean
  • (스터디룸번호) — int — NOT NULL — studyRoom.roomId
  • Field (가입인원) — int — studyRoom.totalP
  • Field (조회수) — int

reply (Untitled4)

  • PK (댓글번호) — int — Primary key — NOT NULL
  • Key (게시글번호) — int — Foreign key → post.Key — NOT NULL
  • PK (스터디룸 번호) — int — Foreign key → post.PK — NOT NULL
  • PK (아이디) — varchar(10) — Foreign key → post.PK — NOT NULL
  • Field (작성자) — varchar(10) — member.memId
  • Field2 (내용) — varchar(500)
  • Field3 (작성날짜) — datetime
  • Field4 (게시글 유형) — int — 0: study 1:QNA
  • Field5 (게시글 번호) — int — post.postId

review (Untitled9)

  • Key (리뷰번호) — int — Primary key — NOT NULL
  • PK (멘토번호) — int — Foreign key → mento.PK — NOT NULL
  • Field (작성자) — varchar(10) — member.memId
  • Field2 (내용) — varchar(500)
  • Field3 (멘토 ID) — int — mento.mentoId
  • PK (아이디) — varchar(10) — Foreign key → member.PK — NOT NULL

studyRoom (Untitled3)

  • PK (스터디룸 번호) — int — Primary key — NOT NULL
  • PK (아이디) — varchar(10) — Foreign key → member.PK — NOT NULL
  • Field (스터디룸 이름) — varchar(20)
  • Field2 (카테고리) — int — 미리 정해진 0~10 중 1개
  • Field3 (스터디장) — varchar(10) — member.memId
  • Field4 (참여학생리스트) — varchar(500)
  • Field5 (가입자수) — int — NOT NULL
  • Field (최대인원수) — int — NOT NULL — maximun = 50