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