test
Tables (10)
AGREE_YN (동의여부)
- SEQ — VARCHAR — Primary key — NOT NULL
- USER_ID (유저ID) — VARCHAR — Foreign key → USER.USER_ID — NOT NULL
- USER_AGREE_YN (이용약관동의) — VARCHAR
- PRIVACY_AGREE_YN (개인정보동의) — VARCHAR
- MARKETING_AGREE_YN (마케팅동의) — VARCHAR
- OVER_14_YN (만14세이상동의) — VARCHAR
BOARD (게시판)
- BOARD_ID (게시판ID) — VARCHAR — Primary key — NOT NULL
- USER_ID (업로더ID) — VARCHAR — Foreign key → USER.USER_ID — NOT NULL
- BOARD_NAME (게시판이름) — VARCHAR
- CONTENT (내용) — VARCHAR
- COUNT (조회수) — INT
- BOARD_PHOTO (게시판사진) — VARCHAR
BOARD_LIKE (게시판 좋아요)
- SEQ — VARCHAR — Primary key — NOT NULL
- BOARD_ID (게시판ID) — VARCHAR — Foreign key → BOARD.BOARD_ID — NOT NULL
- USER_ID (업로더ID) — VARCHAR — Foreign key → BOARD.USER_ID — NOT NULL
- LIKE_ID (좋아요ID) — VARCHAR
BOARD_REPLY (게시판댓글)
- SEQ — VARCHAR — Primary key — NOT NULL
- BOARD_ID (게시판ID) — VARCHAR — Foreign key → BOARD.BOARD_ID — NOT NULL
- USER_ID (업로더ID) — VARCHAR — Foreign key → BOARD.USER_ID — NOT NULL
- REPLY_ID (댓글단 ID) — VARCHAR
- CONTENTS (내용) — VARCHAR
FOLLOW (팔로우정보)
- SEQ — VARCHAR — Primary key — NOT NULL
- USER_ID (팔로잉ID) — VARCHAR — Foreign key → USER.USER_ID — NOT NULL
- FOLLOWED_ID (팔로워ID) — VARCHAR
MENU (메뉴)
- MENU_ID (메뉴ID) — VARCHAR — Primary key — NOT NULL
- TYPE — VARCHAR
- MENU_NAME (이름) — VARCHAR
- PARENT_ID (부모메뉴ID) — VARCHAR
USER (회원)
- USER_ID (유저ID) — VARCHAR — Primary key — NOT NULL
- USER_NAME (이름) — VARCHAR
- PASSWORD (비번) — VARCHAR
- PHOTO (프사) — VARCHAR
- EMAIL — VARCHAR
- NICNAME (닉넴) — VARCHAR
VISIT (방명록)
- VISIT_SEQ (SEQ) — VARCHAR — Primary key — NOT NULL
- USER_ID (유저ID) — VARCHAR — Foreign key → USER.USER_ID — NOT NULL
- VISITING_ID (방문한ID) — VARCHAR
- CONTENTS (내용) — VARCHAR
VISIT_LIKE (방명록 좋아요)
- SEQ — VARCHAR — Primary key — NOT NULL
- VISIT_SEQ (방명록SEQ) — VARCHAR — Foreign key → VISIT.VISIT_SEQ — NOT NULL
- LIKE_ID (좋아요ID) — VARCHAR
VISIT_REPLY (방명록댓글)
- SEQ — VARCHAR — Primary key — NOT NULL
- VISIT_SEQ (방명록SEQ) — VARCHAR — Foreign key → VISIT.VISIT_SEQ — NOT NULL
- REPLY_ID (댓글단 ID) — VARCHAR
- CONTENTS (내용) — VARCHAR