tourlist

Tables (7)

BOARD (게시판)

  • BOARD_ID (Key) — NUM — Primary key — NOT NULL
  • CONTENT_ID (Field) — NUM
  • ADDRESS (Field2) — CHAR
  • IMAGE (Field3) — CHAR
  • TITLE (Field4) — CHAR

BOOKMARK (북마크)

  • ID (Key) — NUM — Primary key — NOT NULL
  • MEMBER_ID (Key2) — NUM — Foreign key → MEMBER.ID — NOT NULL
  • BOARD_ID (Key3) — NUM — Foreign key → BOARD.BOARD_ID — NOT NULL

COMMENTS (댓글)

  • COMMENT_ID (Key) — NUM — Primary key — NOT NULL
  • MEMBER_ID (Key2) — NUM — Foreign key → MEMBER.ID — NOT NULL
  • BOARD_ID (Key3) — NUM — Foreign key → BOARD.BOARD_ID — NOT NULL
  • CONTENT_ID (Field2) — NUM
  • COMMENT_TEXT (Field4) — CHAR

CONTENT (여행메모)

  • ID (Key) — NUM — Primary key — NOT NULL
  • PLANNER_ID (Key2) — NUM — Foreign key → PLANNERS.ID — NOT NULL
  • X (Field) — FLOAT
  • Y (Field2) — FLOAT
  • PLACE_ID (Field3) — NUM
  • ADDRESS (Field5) — CHAR
  • MEMO (Field6) — CHAR
  • PHONE (Field7) — CHAR
  • PLACE_NAME (Field8) — CHAR
  • ROAD_ADDRESS (Field9) — CHAR
  • TOURLIST_DATE (Field10) — CHAR
  • URL (Field11) — CHAR

LIKES (좋아요)

  • LIKE_ID (Key) — NUM — Primary key — NOT NULL
  • MEMBER_ID (Key2) — NUM — Foreign key → MEMBER.ID — NOT NULL
  • BOARD_ID (Key3) — NUM — Foreign key → BOARD.BOARD_ID — NOT NULL

MEMBER (회원)

  • ID (Key) — NUM — Primary key — NOT NULL
  • CREATE_DATE (Field) — DATE
  • EMAIL (Field2) — CHAR
  • MEMBER_TYPE (Field3) — CHAR
  • PASSWORD (Field4) — CHAR
  • REALNAME (Field5) — CHAR
  • USERNAME (Field6) — CHAR

PLANNERS (여행계획)

  • ID (Key) — CHAR — Primary key — NOT NULL
  • MEMBER_ID (Key2) — NUM — Foreign key → MEMBER.ID — NOT NULL
  • CREATE_DATE (Field) — DATE
  • TITLE (Field3) — CHAR