Travel_Maker

Tables (12)

Coupon (Untitled4)

  • Coupon_idx (Key) — Primary key — NOT NULL
  • Coupon_name (Field)
  • Coupon_ValidDate (Field2)
  • Coupon_idx_salePrice (Field3)
  • Coupon_idx_Content (Field5)
  • Coupon_type (1번이면 방만 적용 2번이면 사용자 적용)

Lodge (Untitled3)

  • lodge_detail_idx (Key) — Primary key — NOT NULL
  • lodge_detail_name (Field)
  • lodge_detail_ckReservation (Field3)
  • lodge_detail_rate (Field4)
  • lodge_detail_type (Field5)
  • lodge_detail_RealImgName (Field7)
  • lodge_detail_EncodingImgName (Field8)
  • lodge_detail_address (Field9)
  • lodge_detail_Tel (Field10)
  • lodge_detail_Option (Field11)
  • lodge_detail_Location (Field2)
  • lodge_register_SellerInfo_BusinessNum (Key2) — number — Foreign key → lodge_register_SellerInfo.lodge_register_SellerInfo_BusinessNum — NOT NULL
  • lodge_detail_Content (Field12)

Lodge_Option (Untitled7)

  • Lodge_Option_Fitness (Field)
  • Lodge_Option_SwimminPool (Field2)
  • Lodge_Option_Sauna (Field3)
  • Lodge_Option_Restraunt (Field4)
  • Lodge_Option_BBQ (Field5)
  • Lodge_Option_bathroomSupplies (Field6)
  • Lodge_Option_WIfi (Field7)
  • Lodge_Option_NoneSmoking (Field8)
  • Lodge_Option_Breakfast (Field9)
  • Lodge_Option_Parking (Field10)
  • Lodge_Option_ForDisabled (Field11)

Lodge_Review (Untitled11)

  • Lodge_Review_idx (Key) — Primary key — NOT NULL
  • Lodge_Review_content (Field)
  • Lodge_Review_rate (Field2)
  • Lodge_Review_writer (Field5) — varchar2(100) — Foreign key → TravelMaker_Member.TravelMaker_Member_userid
  • Lodge_Review_RoomTypeIdx (Key2) — Foreign key → Lodge_Room_Type.Lodge_Room_Type_idx — NOT NULL

Lodge_Room_Type (Untitled8)

  • Lodge_Room_Type_idx (Key) — Primary key — NOT NULL
  • Lodge_Room_Type_MinCapacity (Field3)
  • Lodge_Room_Type_Name (Field)
  • Lodge_Room_Type_MaxCapacity (Field2)
  • Lodge_Room_Type_Option (Field4)
  • Lodge_Room_Type_ImageSrc (Field5)
  • Lodge_Room_Type_Price (Field7)
  • Lodge_Room_Type_Count (Field9)
  • lodge_detail_idx (Key2) — Foreign key → Lodge.lodge_detail_idx — NOT NULL
  • Lodge_Room_Type_Coupon (Key4) — Foreign key → Coupon.Coupon_idx — NOT NULL

Meeting_Board

  • Meeting_Board_idx (Key) — Primary key — NOT NULL
  • Meeting_Board_date (Field)
  • Meeting_Board_content (Field2)
  • Meeting_Board_location (Field4)
  • Meeting_Board_writer (Field5) — varchar2(100) — Foreign key → TravelMaker_Member.TravelMaker_Member_userid

Message_storage_box (Untitled12)

  • Message_storage_box_idx (Key) — Primary key — NOT NULL
  • Message_storage_box_date (Field3)
  • Message_storage_box_Content (Field4)
  • Message_storage_box_isRead (Field5)
  • Message_storage_box_isConfirm (Field6)
  • Message_storage_box_GiveUser (Field)
  • Message_storage_box_TakeUser (Field2) — varchar2(100) — Foreign key → TravelMaker_Member.TravelMaker_Member_userid

Recommend_Travel (Untitled5)

  • Recommend_Travel_idx (Key) — Primary key — NOT NULL
  • Recommend_Travel_Address (Field)
  • Recommend_Travel_EventStartDate (Field2)
  • Recommend_Travel_EventEndDate (Field3)
  • Recommend_Travel_Img (Field4)
  • Recommend_Travel_mapX (Field5)
  • Recommend_Travel_mapY (Field6)
  • Recommend_Travel_maplevel (Field7)
  • Recommend_Travel_tel (Field8)
  • Recommend_Travel_title (Field9)
  • Recommend_Travel_location (Field10)

Reserved_Lodge_current_state (Untitled13)

  • Reserved_Lodge_cuurent_state_idx (Key2) — Primary key — NOT NULL
  • Reserved_Lodge_cuurent_state_date (Field2)
  • Reserved_Lodge_cuurent_state_userid (Field) — varchar2(100) — Foreign key → TravelMaker_Member.TravelMaker_Member_userid
  • Reserved_Lodge_cuurent_state_RoomIdx (Key) — Foreign key → Lodge_Room_Type.Lodge_Room_Type_idx — NOT NULL

TravelMaker_Member (Untitled)

  • TravelMaker_Member_userid (Field) — varchar2(100) — Primary key
  • TravelMaker_Member_userpw (filed2) — varchar2(100)
  • TravelMaker_Member_sort (Field3) — varchar2(500)
  • TravelMaker_Member_username (Field4) — varchar2(100)
  • TravelMaker_Member_usernickname (Field5) — varchar2(100)
  • TravelMaker_Member_email (Field6) — varchar2(100)
  • TravelMaker_Member_birth (Field2) — date
  • TravelMaker_Member_gender (Field7) — varchar2(100)
  • TravelMaker_Member_RealProfileImg (Field8) — varchar2(300)
  • TravelMaker_Member_EncodingProfileImg (Field9) — varchar2(300)
  • TravelMaker_Member_PNum (Field10) — varchar2(100)
  • TravelMaker_Member_ReservedLodge (Field11) — number
  • TravelMaker_Member_isAdmin (Field13)
  • TravelMaker_Member_Favorite (Field14)
  • TravelMaker_Member_Coupon (Key2) — Foreign key → Coupon.Coupon_idx — NOT NULL
  • TravelMaker_Member_idx (Key) — number — NOT NULL

lodge_register_SellerInfo (Untitled10)

  • lodge_register_SellerInfo_BusinessNum (Key) — number — Primary key — NOT NULL
  • lodge_register_SellerInfo_CompanyName (Field)
  • lodge_register_SellerInfo_Address (Field2)
  • lodge_register_SellerInfo_CEOName (Field3)
  • lodge_register_SellerInfo_Tel (Field4)
  • lodge_register_SellerInfo_Email (Field5)

lodge_register_content (Untitled9)

  • lodge_register_content_aroundInfo (Field)
  • lodge_register_content_StandardInfo (Field2)
  • lodge_register_content_AddMemberInfo (Field3)
  • lodge_register_content_AmenityInfo (Field4)
  • lodge_register_content_RuleInfo (Field5)