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)