KOALABOOK

koalabook_content

Tables (6)

BOARD (board)

  • w_number (게시판고유번호) — primary key — Primary key — NOT NULL
  • userID (아이디) — primary key — Foreign key → KOALA_NAVER_TBL.userID — NOT NULL
  • title (제목)
  • passward (비밀번호)
  • content (게시판내용)
  • writeday (글쓴날짜)

COMMENTS_TBL (comments_tbl)

  • userID (아이디) — primary key — Foreign key → TBL_USER2.userID — NOT NULL
  • w_number (게시물번호) — references board(w_number)
  • comments (댓글)
  • comments_num (댓글번호) — sequence

KOALA_KAKAO_TBL (koala_kakao_tbl)

  • userID (아이디) — Foreign key → BOARD.userID — NOT NULL
  • email (이메일) — not null
  • nickname (닉네임)
  • gender (성별)
  • userID (아이디2) — primary key — Foreign key → COMMENTS_TBL.userID — NOT NULL

KOALA_NAVER_TBL (koala_naver_tbl)

  • userID (아이디) — primary key — Primary key — NOT NULL
  • name (이름) — not null
  • email (이메일) — not null
  • gender (성별)
  • birthday (생월일)
  • birthyear (생년)
  • phone (전화번호)
  • userID (아이디2) — primary key — Foreign key → COMMENTS_TBL.userID — NOT NULL

TBL_LOGIN_LOG (tbl_login_log)

  • time (날짜) — Primary key
  • userID (아이디) — primary key — Foreign key → BOARD.userID — NOT NULL
  • userID (아이디2) — primary key — Foreign key → TBL_USER2.userID — NOT NULL

TBL_USER2 (tbl_user2)

  • userID (아이디) — primary key — Primary key — NOT NULL
  • name (이름) — Primary key
  • userPassword (비밀번호)
  • email (이메일)
  • phoneNumber (전화번호) — unique
  • birth (생년월일)
  • addr1 (우편번호)
  • addr2 (주소)
  • addr3 (상세주소)