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 (상세주소)