스터디룸

테이블 (6)

게시판 (리뷰, 개선점)

  • boardId (Key) — long — 기본 키 — NOT NULL
  • name (Field) — varchar(10)
  • content (Field2) — varchar(100)
  • boardCreateDt (Field3) — date
  • boardUpdateDt (Field4) — date
  • boardPassword (Field5) — varchar(20)

댓글 (Untitled6)

  • commentId (Key) — long — 기본 키 — NOT NULL
  • content (내용) — varchar(50)
  • commentCreateDt (등록일) — date
  • commentUpdateDt (수정일) — date
  • roomId (Key2) — long — 외래 키 → 룸 종류.roomId — NOT NULL
  • memberId (Key3) — long — 외래 키 → 회원.memberPKId — NOT NULL

룸 종류 (Untitled3)

  • roomId (Key) — long — 기본 키 — NOT NULL
  • roomPrice (Field) — long
  • roomPerson (Field3) — int

예약 (Untitled2)

  • reservationId (Key) — long — 기본 키 — NOT NULL
  • reservationDt (Field2) — date
  • reservationCreateDt (Field3) — date
  • memberId (Key2) — long — 외래 키 → 회원.memberPKId — NOT NULL
  • roomId (Key3) — long — 외래 키 → 룸 종류.roomId — NOT NULL

예약 가능 날짜 (Untitled4)

  • possibleDtId (Key) — long — 기본 키 — NOT NULL
  • possibleRoomDt (Field) — date
  • roomId (Key2) — long — 외래 키 → 룸 종류.roomId — NOT NULL

회원 (Untitled)

  • memberPKId (Key) — long — 기본 키 — NOT NULL
  • memberPassword (Field) — varchar(50)
  • memberName (Field2) — varchar(12)
  • phone (Field3) — varchar(20)
  • memberEmail (Field4) — varchar(30)
  • memberBirth (Field5) — date
  • memberCreateDt (Field6) — date
  • memberId (Field8) — varchar(50)