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