ourtrip
Tables (17)
boardFree (자유게시판)
- board_no (Key) — int — Primary key — NOT NULL
- board_name (Field) — varchar
- id (Field2) — varchar
- member_no (Field3) — int
- title (Field4) — varchar
- content (Field5) — text
- viewcount (Field6) — int
- writedate (Field7) — timestamp
- updatedate (Field8) — timestamp
- filename_org (Field9) — varchar
- filename_server (Field10) — varchar
- member_no (Key2) — int — Foreign key → member.member_no — NOT NULL
boardQna (CopyOf자유게시판)
- board_no (Key) — int — Primary key — NOT NULL
- board_name (Field) — varchar
- id (Field2) — varchar
- member_no (Field3) — int
- title (Field4) — varchar
- content (Field5) — text
- viewcount (Field6) — int
- writedate (Field7) — timestamp
- updatedate (Field8) — timestamp
- filename_org (Field9) — varchar
- filename_server (Field10) — varchar
- gno (Field11) — int
- ono (Field12) — int
- nested (Field13) — int
- member_no (Key2) — int — Foreign key → member.member_no — NOT NULL
boardTravel (여행게시판)
- board_no (Key) — int — Primary key — NOT NULL
- board_name (Field) — varchar
- id (Field2) — varchar
- member_no (Field3) — int
- title (Field4) — varchar
- viewcount (Field5) — int
- writedate (Field6) — timestamp
- updatedate (Field7) — timestamp
- member_no (Key2) — int — Foreign key → member.member_no — NOT NULL
boardcourse (여행코스)
- board_no (Key2) — int — Primary key — NOT NULL
- course_no (Key3) — int — Primary key — NOT NULL
- board_name (Field2) — varchar
- content (Field3) — text
- board_no (Key) — int — Foreign key → boardTravel.board_no — NOT NULL
category (카테고리)
- board_no (Field) — int
- board_name (Field2) — varchar
- hashtag_no (Field3) — int
- region_no (Field4) — int
- board_no (Key) — int — Foreign key → boardTravel.board_no — NOT NULL
- hashtag_no (Key2) — int — Foreign key → hashtag.hashtag_no — NOT NULL
- region_no (Key3) — int — Foreign key → region.region_no — NOT NULL
chat (채팅내역)
- chat_no (Key) — int — Primary key — NOT NULL
- board_name (Field) — varchar
- board_no (Field2) — int
- room_no (Field3) — int
- member_id (Field4) — varchar
- member_no (Field5) — int
- content (Field6) — varchar
- chat_writedate (Field7) — timestamp
- room_no (Key2) — int — Foreign key → room.room_no — NOT NULL
- roommaker_id (Key22) — varchar — Foreign key → room.roommaker_id — NOT NULL
dislike (싫어요)
- board_no (Key) — int — Primary key — NOT NULL
- board_name (Key2) — varchar — Primary key — NOT NULL
- member_no (Key3) — varchar — Primary key — NOT NULL
- board_no (Key4) — int — Foreign key → boardTravel.board_no — NOT NULL
- member_no (Key5) — int — Foreign key → member.member_no — NOT NULL
- board_no (Key6) — int — Foreign key → boardQna.board_no — NOT NULL
- board_no (Key7) — int — Foreign key → boardFree.board_no — NOT NULL
file (Untitled)
- board_name (Field) — varchar
- board_no (Field2) — int
- filename_org (Field3) — varchar
- filename_server (Field4) — varchar
- course_no (Field5) — int
- board_no (Key2) — int — Foreign key → boardcourse.board_no — NOT NULL
- course_no (Key3) — int — Foreign key → boardcourse.course_no — NOT NULL
hashtag (해시태그)
- hashtag_no (Key) — int — Primary key — NOT NULL
- hashtag_name (Field) — varchar
like (좋아요)
- board_no (Key) — int — Primary key — NOT NULL
- board_name (Key2) — varchar — Primary key — NOT NULL
- member_no (Key3) — varchar — Primary key — NOT NULL
- board_no (Key4) — int — Foreign key → boardTravel.board_no — NOT NULL
- member_no (Key5) — int — Foreign key → member.member_no — NOT NULL
- board_no (Key6) — int — Foreign key → boardQna.board_no — NOT NULL
- board_no (Key7) — int — Foreign key → boardFree.board_no — NOT NULL
map (지도정보)
- board_no (Field) — int
- course_no (Field2) — int
- place_name (Field3) — varchar
- x (Field4) — varchar
- y (Field5) — varchar
- address_name (Field6) — varchar
- road_address_name (Field7) — varchar
- phone (Field8) — varchar
- place_url (Field9) — varchar
- id (Field10) — varchar
- category_group_code (Field11) — varchar
- category_group_name (Field12) — varchar
- category_name (Field13) — varchar
- board_no (Key2) — int — Foreign key → boardcourse.board_no — NOT NULL
- course_no (Key3) — int — Foreign key → boardcourse.course_no — NOT NULL
member (Untitled6)
- member_no (Key) — int — Primary key — NOT NULL
- id (Field) — varchar
- pwd (Field2) — varchar
- email (Field3) — varchar
- m_filename_org (Field4) — varchar
- m_filename_server (Field5) — varchar
- regdate (Field6) — timestamp
- nickname (Field7) — varchar
message (Untitled7)
- message_no (Key) — int — Primary key — NOT NULL
- send_member_no (Field) — int
- receive_member_no (Field2) — int
- message_content (Field3) — text
- senddate (Field4) — timestamp
- readdate (Field5) — timestamp
- show_send (Field7) — int
- show_receive (Field6) — int
- member_no (Key2) — int — Foreign key → member.member_no — NOT NULL
region (Untitled3)
- region_no (Key) — int — Primary key — NOT NULL
- region_name (Field) — varchar
reply (Untitled8)
- reply_no (Key) — int — Primary key — NOT NULL
- board_no (Field) — int
- board_name (Field2) — varchar
- member_id (Field3) — varchar
- content (Field4) — content
- member_no (Field5) — int
- reply_likecount (Field6) — int
- reoly_writedate (Field7) — timestamp
- gno (Field8) — int
- ono (Field9) — int
- board_no (Key2) — int — Foreign key → boardTravel.board_no — NOT NULL
- member_no (Key3) — int — Foreign key → member.member_no — NOT NULL
- board_no (Key4) — int — Foreign key → boardQna.board_no — NOT NULL
- board_no (Key5) — int — Foreign key → boardFree.board_no — NOT NULL
room (여행모임방)
- room_no (Key) — int — Primary key — NOT NULL
- roommaker_id (Key2) — varchar — Primary key — NOT NULL
- board_no (Field) — int
- board_name (Field2) — varchar
- room_title (Field3) — varchar
- room_content (Field4) — text
- room_makedate (Field5) — timestamp
- room_startdate (Field6) — char
- room_enddate (Field7) — char
- room_pwd (Field8) — varchar
- board_no (Key3) — int — Foreign key → boardTravel.board_no — NOT NULL
roommember (Untitled5)
- room_no (Field) — int
- room_participant_no (Field2) — int
- room_no (Key) — int — Foreign key → room.room_no — NOT NULL
- roommaker_id (Key2) — varchar — Foreign key → room.roommaker_id — NOT NULL