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