PLND STAY
Tables (42)
ACCOMM (숙소 기초정보)
- intAID — int — Primary key — NOT NULL — 시설코드
- strDeleteYn — char(1) — NOT NULL — 삭제여부
- strViewYn — char(1) — NOT NULL — 노출여부
- strType — varchar(3) — NOT NULL — 시설 구분( ACCOMM_TYPE )
- strCateCode — varchar(3) — 시설 분류( ACCOMM_CATE )
- intAbleCancel — tinyint — NOT NULL — 취소가능일(X일 전)
- strDistrict1 — varchar(20) — 시도( CODE_DISTRICT )
- strDistrict2 — varchar(20) — 시군구( CODE_DISTRICT )
- strDistrict3 — varchar(20) — 구군읍면( CODE_DISTRICT )
- strSubject — nvarchar(50) — NOT NULL — 시설명
- strPropertyID — varchar(20) — 공급사 시설코드
- intOldCID — int — (이전) 시설 일련번호
- dateCreated — datetime — NOT NULL — 생성일
- dateModified — datetime — NOT NULL — 수정일
ACCOMM_ACM_LOCAL (숙소-시설 연결)
- intIdx — int — Primary key — NOT NULL
- intAID — int — NOT NULL
- intALIIdx — int — NOT NULL
- dateModified — datetime — NOT NULL
ACCOMM_ADD_FAC (숙소 부대시설)
- intIdx — int — Primary key — NOT NULL
- intAID — int — NOT NULL
- strCode — varchar(3) — NOT NULL
ACCOMM_AROUND (숙소 주변 명소)
- intIdx — int — NOT NULL
- intAID — int — NOT NULL
- strAroundSpot — nvarchar(20) — NOT NULL
- intStep — tinyint — NOT NULL
ACCOMM_AUTO_FAX (숙소 자동 팩스 설정)
- intIdx — int — Primary key — NOT NULL
- intAID — int — NOT NULL
- strSendType — varchar(3)
- intRsvDays — smallint — NOT NULL
- strWeekdaysYn — char(1) — NOT NULL
- strSatYn — char(1) — NOT NULL
- strHoliYn — char(1) — NOT NULL
- timeWeekdaysS — char(5)
- timeWeekdaysE — char(5)
- timeSaturdayS — char(5)
- timeSaturdayE — char(5)
- strCompFax — varchar(20)
- strLocalFax — varchar(20)
- strCompPerson — nvarchar(50)
- strLocalPerson — nvarchar(50)
- dateCreated — datetime — NOT NULL
- dateModified — datetime — NOT NULL
ACCOMM_CANCEL_RULES (숙소 취소규정)
- intIdx — int — Primary key — NOT NULL
- intAID — int — NOT NULL
- strFlag — varchar(3) — NOT NULL
- intDay — tinyint — NOT NULL
- intPercent — tinyint — NOT NULL
ACCOMM_CONTACT (숙소 연락처(담당자 등))
- intIdx — int — Primary key — NOT NULL
- intAID — int — NOT NULL
- strFlag — varchar(3) — NOT NULL
- strSubject — nvarchar(50)
- strContact — nvarchar(100) — NOT NULL
- intModifiedSID — int — NOT NULL
- dateModified — datetime — NOT NULL
ACCOMM_INFO (숙소 부가정보)
- intAID — int — Primary key — NOT NULL
- strPayPlanTime — varchar(3)
- strPayPlanType — varchar(3)
- strAcctBank — varchar(3)
- strAcctNum — varchar(20)
- strAcctName — nvarchar(20)
- yyCompletion — char(4)
- mmCompletion — char(2)
- decLat — decimal(13, 10)
- decLon — decimal(13, 10)
- intZoom — tinyint
- intGrade — tinyint
- intRoomCnt — smallint
- strCheckIn — nvarchar(50)
- strCheckOut — nvarchar(50)
- strInformWay — varchar(20)
- strPhone — varchar(20)
- strBizPhone — varchar(20)
- strFax — varchar(20)
- strCorpNumber — varchar(15)
- strEmail — varchar(100)
- strZipCode — char(5)
- strAddr1 — nvarchar(100)
- strAddr2 — nvarchar(100)
- strWebsite — nvarchar(200)
- strPenaltyInner — nvarchar(4000)
- strShortDesc — nvarchar(4000)
- strDescription — nvarchar(max)
- strTraffic — nvarchar(max)
- strRsvGuide — nvarchar(max)
- strAround — nvarchar(max)
- strAddFac — nvarchar(max)
- strAcmNotice — nvarchar(max)
- strOMKDetailInfo — nvarchar(max)
ACCOMM_KEYWORD (숙소 키워드(오픈마켓 겸용))
- intIdx — int — Primary key — NOT NULL
- intAID — int — NOT NULL
- strKeyword — nvarchar(50) — NOT NULL
- intStep — tinyint — NOT NULL
ACCOMM_MANAGER (숙소 담당직원)
- intIdx — int — Primary key — NOT NULL
- intAID — int — NOT NULL
- intSID — int — NOT NULL
- intStep — tinyint
ACCOMM_OMK (오픈마켓 별 숙소 정보)
- intIdx — int — Primary key — NOT NULL
- intAID — int — NOT NULL
- intOMKIdx — int — NOT NULL
- strUsageYn — char(1) — NOT NULL
- strPdtSubject — nvarchar(100)
- strPdtCode — varchar(20)
- strDetailInfo — nvarchar(max)
ACCOMM_OMK_INFO (숙소 오픈마켓별 정보)
- intAID — int — Primary key — NOT NULL
- str11stCate1 — varchar(20)
- str11stCate2 — varchar(20)
- str11stCate3 — varchar(20)
- str11stCate4 — varchar(20)
- strTour11stCate1 — varchar(20)
- strTour11stCate2 — varchar(20)
- strTour11stCate3 — varchar(20)
- strGmkCate1 — varchar(20)
- strGmkCate2 — varchar(20)
- strGmkCate3 — varchar(20)
- strGmkBrand — varchar(20)
- strAucCate1 — varchar(20)
- strAucCate2 — varchar(20)
- strAucCate3 — varchar(20)
- strEbayCate1 — varchar(20)
- strEbayCate2 — varchar(20)
- strEbayDist1 — varchar(20)
- strEbayDist2 — varchar(20)
- strElandCate1 — varchar(20)
- strElandCate2 — varchar(20)
- strElandDisplay — varchar(20)
- strEzwelCate1 — varchar(20)
- strEzwelCate2 — varchar(20)
- strEzwelDist1 — varchar(20)
- strEzwelDist2 — varchar(20)
ACCOMM_PEAK_SEASON (숙소 성수기 구간)
- intIdx — int — Primary key — NOT NULL
- intAID — int — NOT NULL
- datePeakS — char(10) — NOT NULL
- datePeakE — char(10) — NOT NULL
ACCOMM_PHOTO (숙소 사진)
- intAID — int — Primary key — NOT NULL
- intStep — tinyint — Primary key — NOT NULL
- intPhotoID — int — NOT NULL
ACCOMM_REVIEW (숙소 리뷰)
- intIdx — int — Primary key — NOT NULL
- intAID — int — NOT NULL
- strDeleteYn — char(1) — NOT NULL
- strViewYn — char(1) — NOT NULL
- intRsvID — int — NOT NULL
- intUID — int — NOT NULL
- strName — nvarchar(20) — NOT NULL
- strReview — nvarchar(4000)
- dateReview — datetime — NOT NULL
- intModifiedSID — int
- dateModified — datetime
ACM_LOCAL_INFO (시설 영업장 정보)
- intIdx — int — NOT NULL
- strDeleteYn — char(1) — NOT NULL
- strUsageYn — char(1) — NOT NULL
- strFlag — varchar(10) — NOT NULL
- strLocalCode — varchar(20) — NOT NULL
- strLocalName — nvarchar(50) — NOT NULL
- strStoreCode — varchar(20)
- strStoreName — nvarchar(50)
- strRmCode — varchar(20)
- strRmName — nvarchar(100)
ACM_PACKAGE_INFO (시설 패키지 정보)
- intIdx — int — NOT NULL
- strDeleteYn — char(1) — NOT NULL
- strUsageYn — char(1) — NOT NULL
- strFlag — varchar(10) — NOT NULL
- strPkgCode — varchar(20) — NOT NULL
- strPkgName — nvarchar(100) — NOT NULL
- strLocalCode — varchar(20)
- strLocalName — nvarchar(50)
- strStoreCode — varchar(20)
- strStoreName — nvarchar(50)
- dateStart — date — NOT NULL
- dateEnd — date — NOT NULL
- dateSaleS — date
- dateSaleE — date
- intMaxRmCount — tinyint — NOT NULL
- strTodayRsvYn — char(1) — NOT NULL
- strTodayRsvTime — char(5)
- intStayDays — tinyint
- strPkgSubCode — varchar(20)
- dateCreated — datetime — NOT NULL
- dateModified — datetime — NOT NULL
ACM_PACKAGE_RM_DATA (시설 패키지 적용 객실 정보)
- intIdx — int — NOT NULL
- intAPIIdx — int — NOT NULL
- strRmCdoe (strRmCode) — varchar(20) — NOT NULL
- strRmName — nvarchar(100)
- dateModified — datetime — NOT NULL
CODE_DISTRICT (지역 코드)
- intIdx — int — Primary key — NOT NULL
- strDeleteYn — char(1) — NOT NULL
- intDepth — tinyint — NOT NULL
- strCode — varchar(10) — NOT NULL
- strName — nvarchar(20) — NOT NULL
- strName2 — nvarchar(20)
CODE_OMK (오픈마켓 용 코드)
- intIdx — int — Primary key — NOT NULL
- strDeleteYn — char(1) — NOT NULL
- strCateCode — varchar(30) — NOT NULL
- strCode — nvarchar(20) — NOT NULL
- strName — nvarchar(50) — NOT NULL
- strParentCode — nvarchar(20)
- intStep — smallint — NOT NULL
- intDepth — tinyint — NOT NULL
- intParentIdx — int — NOT NULL
CODE_SYSTEM (관리자 용 코드)
- intIdx — int — Primary key — NOT NULL
- strDeleteYn — char(1) — NOT NULL
- strUsageYn — char(1) — NOT NULL
- strViewYn — char(1) — NOT NULL
- strCateCode — varchar(30) — NOT NULL
- strCode — nvarchar(20) — NOT NULL
- strName — nvarchar(50) — NOT NULL
- strOpt1 — nvarchar(100)
- strOpt2 — nvarchar(100)
- strOpt3 — nvarchar(4000)
- strOpt4 — nvarchar(100)
- intStep — smallint — NOT NULL
CONNECTION_CONTACT (거래처 담당자 등 연락처)
- intIdx — int — Primary key — NOT NULL
- strRsvMailYn — char(1) — NOT NULL
- strRelType — varchar(3)
- intRelIdx — int
- strFlag — nvarchar(20)
- strName — nvarchar(50)
- strPhone — varchar(20)
- strMobile — varchar(20)
- strFax — varchar(20)
- strEmail — varchar(100)
- strMessangerID — varchar(100)
- intCreatedSID — int — NOT NULL
- dateCreated — datetime — NOT NULL
- intModifiedSID — int — NOT NULL
- dateModified — datetime — NOT NULL
CONTENTS_PHOTO (사진 콘텐츠)
- intPhotoID — int — Primary key — NOT NULL
- strSubject — nvarchar(100) — NOT NULL
- strFilePath — varchar(100)
- strFileName — varchar(100)
- intCreatedSID — int — NOT NULL
- dateCreated — datetime — NOT NULL
- intModifiedSID — int — NOT NULL
- dateModified — datetime — NOT NULL
EDITOR_DATA (에디터 정보)
- intIdx — int — Primary key — NOT NULL
- strFileKey — varchar(20) — NOT NULL
- strFileGroup — varchar(50)
- strFileCode — varchar(50)
- strFileType — char(1) — NOT NULL
- strFilePath — varchar(200) — NOT NULL
- strFileName — nvarchar(200) — NOT NULL
- strRealName — nvarchar(200) — NOT NULL
- intFileSize — int — NOT NULL
- dateCreated — datetime — NOT NULL
ERP_CONFIG_MENU (관리자 메뉴)
- intIdx — int — Primary key — NOT NULL
- strDeleteYn — char(1) — NOT NULL
- strUsageYn — char(1) — NOT NULL
- strDevOnlyYn — char(1) — NOT NULL
- strLinkType — char(1) — NOT NULL
- intDepth — int — NOT NULL
- intParentIdx — int — NOT NULL
- intStep — int — NOT NULL
- strLocation1 — varchar(50)
- strLocation2 — varchar(50)
- strIcon — varchar(50)
- strSubject — nvarchar(100) — NOT NULL
- strUrl — varchar(200)
- strSubDisplay — char(2) — NOT NULL
- strSubStyle — varchar(500)
- strCountColumn — nvarchar(100)
- strCountFrom — nvarchar(4000)
- strCountWhere — nvarchar(4000)
HOLIDAY (휴무일)
- intIdx — int — Primary key — NOT NULL
- dateHoliday — date — NOT NULL
- strUsageFax — char(1) — NOT NULL
- strUsageCoupon — char(1) — NOT NULL
- strHoliday — nvarchar(50)
- intCreatedSID — int — NOT NULL
- dateCreated — datetime — NOT NULL
- intModifiedSID — int — NOT NULL
- dateModified — datetime — NOT NULL
OMK (오픈마켓 기초정보)
- intIdx — int — Primary key — NOT NULL
- strDeleteYn — char(1) — NOT NULL
- strType — char(1) — NOT NULL
- decComm — decimal(5, 2)
- strSubject — nvarchar(20) — NOT NULL
- strOrdName — nvarchar(10)
- strIconUrl — varchar(50)
OMK_CONTACT (오픈마켓 연락처(담당자 등))
- intIdx — int — Primary key — NOT NULL
- strDeleteYn — char(1) — NOT NULL
- intOMKIdx — int — NOT NULL
- strWorkYn — char(1) — NOT NULL
- strSendMailYn — char(1) — NOT NULL
- strSendSmsYn — char(1) — NOT NULL
- strName — nvarchar(20) — NOT NULL
- strPhone — varchar(30)
- strMobile — varchar(30)
- strFax — varchar(30)
- strMessengerID — varchar(100)
- strEmail — varchar(100)
- strHostID — nvarchar(20)
- strHostPWD — binary(100)
- intLoginCnt — int — NOT NULL
- intCreatedSID — int — NOT NULL
- dateCreated — datetime — NOT NULL
- intModifiedSID — int — NOT NULL
- dateModified — datetime — NOT NULL
OMK_CONTACT_LOGIN_LOG (오픈마켓 담당자 로그인 로그)
- intIdx — int — Primary key — NOT NULL
- intOMKIdx — int — NOT NULL
- intOCIdx — int — NOT NULL
- strIP — varchar(15) — NOT NULL
- dateCreated — datetime — NOT NULL
RMTYPE (객실 &옵션)
- intIdx — int — Primary key — NOT NULL
- strDeleteYn — char(1) — NOT NULL
- strIngYn — char(1) — NOT NULL
- intAID — int — NOT NULL
- intDepth — tinyint — NOT NULL
- intParentIdx — int
- intStep — smallint — NOT NULL
- strRefundYn — char(1) — NOT NULL
- intQuanStd — tinyint — NOT NULL
- intQuanMax — tinyint — NOT NULL
- intMinSleep — tinyint — NOT NULL
- intMaxSleep — tinyint — NOT NULL
- moneyExtraA — money — NOT NULL
- moneyExtraC — money — NOT NULL
- moneyExtraB — money — NOT NULL
- strSubject — nvarchar(100) — NOT NULL
- strShortDesc — nvarchar(1000)
- strDescription — nvarchar(4000)
- strRmtypeID — varchar(20)
- strRateplanID — varchar(20)
- dateModified — datetime — NOT NULL
- intOldPIdx — int
RM_BEDTYPE (객실 베드타입)
- intRmIdx — int — NOT NULL
- strCateCode — varchar(3) — NOT NULL
RM_ICON (객실 아이콘)
- intRmIdx — int — NOT NULL
- strCateCode — varchar(3) — NOT NULL
RM_OMK_USAGE (오픈마켓별 객실 연동여부)
- intIdx — int — Primary key — NOT NULL
- intRmIdx — int — NOT NULL
- intOMKIdx — int — NOT NULL
- strUsageYn — char(1) — NOT NULL
RM_OPTION (객실 기타옵션)
- intRmIdx — int — NOT NULL
- moneyCostA — money — NOT NULL
- moneyCostB — money — NOT NULL
- moneyCostC — money — NOT NULL
- moneySalesA — money — NOT NULL
- moneySalesB — money — NOT NULL
- moneySalesC — money — NOT NULL
- dateAbled — char(10) — NOT NULL
RM_PHOTO (객실 사진)
- intIdx — int — Primary key — NOT NULL
- intRmIdx — int — NOT NULL
- intPhotoID — int — NOT NULL
- intStep — tinyint — NOT NULL
STAFFS (직원)
- intSID — int — Primary key — NOT NULL
- strDeleteYn — char(1) — NOT NULL
- strID — varchar(20) — NOT NULL
- strPWD — binary(100) — NOT NULL
- strName — nvarchar(20) — NOT NULL
- strMobile — varchar(13)
- strDirectPhone — varchar(13)
- strInlineNo — varchar(4)
- strMessengerID — varchar(100)
- strEmail — varchar(100)
- strOfficeCode — varchar(3) — NOT NULL
- strJobTitleCode — varchar(3)
- strDivisionCode — varchar(3)
- strTeamCode — varchar(3)
- strTypeCode — varchar(3)
- strStateCode — varchar(3)
- strDevYn — char(1) — NOT NULL
- intLoginCnt — int
- dateBirth — date
- dateJoin — date
- dateCreated — datetime — NOT NULL
STAFFS_ERP_CONFIG_MENU (직원 메뉴권한)
- intSID — int — NOT NULL
- intECMIdx — int — NOT NULL
- strLevel — char(1)
STAFFS_LOGIN_LOG (직원 로그인 로그)
- intIdx — int — Primary key — NOT NULL
- intSID — int — NOT NULL
- strIP — varchar(15) — NOT NULL
- dateCreated — datetime — NOT NULL
STAFFS_SCHEDULE (직원 일정표)
- intIdx — int — Primary key — NOT NULL
- strDeleteYn — char(1) — NOT NULL
- strTeam — char(1) — NOT NULL
- strPublic — char(1) — NOT NULL
- strAllDay — char(1) — NOT NULL
- dateStart — date — NOT NULL
- timeStart — time(5)
- dateEnd — date
- timeEnd — time(5)
- strColorCode — varchar(3) — NOT NULL
- strSubject — nvarchar(50) — NOT NULL
- strContent — nvarchar(max)
- intSID — int
- dateCreated — datetime — NOT NULL
STOCK_OMK (오픈마켓 별 별도 재고)
- intIdx — int — Primary key — NOT NULL
- intStockIdx — int — NOT NULL
- intOMKIdx — int — NOT NULL
- intStock — smallint — NOT NULL
- moneySales — money — NOT NULL
- dateModified — datetime — NOT NULL
STOCK_REAL (실재고)
- intIdx — int — Primary key — NOT NULL
- intAID — int — NOT NULL
- intRmIdx — int — NOT NULL
- dateSales — char(10) — NOT NULL
- intStock — smallint — NOT NULL
- moneyCost — money — NOT NULL
- moneySales — money — NOT NULL
- moneyExtraA — money — NOT NULL
- moneyExtraC — money — NOT NULL
- moneyExtraB — money — NOT NULL
- intOMKStock — smallint — NOT NULL
- moneyOMKSales — money — NOT NULL
- dateAbleRsv — char(10)
- dateModified — datetime — NOT NULL
STOCK_TEMP (임시재고)
- intIdx — int — Primary key — NOT NULL
- intAID — int — NOT NULL
- intRmIdx — int — NOT NULL
- dateSales — char(10) — NOT NULL
- intStock — smallint — NOT NULL
- moneyCost — money — NOT NULL
- moneySales — money — NOT NULL
- moneyExtraA — money — NOT NULL
- moneyExtraC — money — NOT NULL
- moneyExtraB — money — NOT NULL
- intOMKStock — smallint — NOT NULL
- moneyOMKSales — money — NOT NULL
- dateAbleRsv — char(10)
- dateModified — datetime — NOT NULL