서울스테이

테이블 (17)

B2C 숙소관리 (SS_T_ROOM_INFO)

  • ROOM_SEQ — number — 기본 키 — NOT NULL
  • USER_SEQ — number — 외래 키 → 숙소관리(공통).USER_SEQ — NOT NULL
  • LANG — varchar(10)
  • TITLE — varchar(20)
  • ROOM_FORM_CD — varchar(20)
  • LOCATION_CD — varchar(10)
  • ADRESS — varchar(100)
  • ADRESS2 — varchar(100)
  • LANGUAGE — varchar(100)

B2C 숙소소개 (SS_T_ROOM_INTRO)

  • INTRO_SEQ — number — 기본 키 — NOT NULL
  • USER_SEQ — number — 외래 키 → 숙소관리(공통).USER_SEQ — NOT NULL
  • LANG — varchar(10)
  • INFO — clob
  • INTRO — clob
  • TRAFFIC — clob
  • STATE_YN — varchar(10)

B2C 숙소옵션 (SS_T_ROOM_OPT)

  • OPT_SEQ — number — 기본 키 — NOT NULL
  • USER_SEQ — number — 외래 키 → 숙소관리(공통).USER_SEQ — NOT NULL
  • LANG — varchar(10)
  • OPT_CD — varchar(10)

B2C 숙소유형 (SS_T_ROOM_TYPE)

  • TYPE_SEQ — number — 기본 키 — NOT NULL
  • USER_SEQ — number — 외래 키 → 숙소관리(공통).USER_SEQ — NOT NULL
  • LANG — varchar(10)
  • CODE — varchar(10)
  • COUNT — int
  • PEOPLE — int

번역요청 (SS_ROOM_TRANS)

  • TRANS_SEQ — number — 기본 키 — NOT NULL
  • USER_SEQ — number — 외래 키 → 숙소관리(공통).USER_SEQ — NOT NULL
  • CONTENT — clob

세부홍보물물품 (SS_PROMOTIONAL_LIST)

  • PROMOTE_SEQ — number — 외래 키 → 홍보물물품관리.PROMOTE_SEQ — NOT NULL
  • POM_CD — varchar(10)
  • COUNT — number

숙소관리 (SS_ROOM_INFO)

  • ROOM_SEQ — number — 기본 키 — NOT NULL
  • USER_SEQ — number — 외래 키 → 숙소관리(공통).USER_SEQ — NOT NULL
  • LANG — varchar(10)
  • TITLE — varchar(20)
  • ROOM_FORM_CD — varchar(20)
  • LOCATION_CD — varchar(10)
  • ADRESS — varchar(100)
  • ADRESS2 — varchar(100)
  • LANGUAGE — varchar(100)

숙소관리(공통) (SS_ROOM_COM)

  • USER_SEQ — number — 외래 키 → 회원관리.USER_SEQ — NOT NULL
  • MANAGER — varchar(20)
  • MANAGER_PHONE — varchar(13)
  • POST_CODE — varchar(10)
  • PASS_PHONE — varchar(13)
  • SIGUNGU — varchar(10)
  • SITE1 — varchar(100)
  • SITE2 — varchar(100)
  • SITE3 — varchar(100)
  • CHECKIN — varchar(5)
  • CHECKOUT — varchar(5)
  • INCHARGE — varchar(20)
  • POST_FORM — varchar(20)
  • STATE — varchar(10)
  • REGISTRATION_DATE — date

숙소소개 (SS_ROOM_INTRO)

  • INTRO_SEQ — number — 기본 키 — NOT NULL
  • USER_SEQ — number — 외래 키 → 숙소관리(공통).USER_SEQ — NOT NULL
  • LANG — varchar(10)
  • INFO — clob
  • INTRO — clob
  • TRAFFIC — clob
  • STATE — varchar(10)

숙소옵션 (SS_ROOM_OPT)

  • OPT_SEQ — number — 기본 키 — NOT NULL
  • USER_SEQ — number — 외래 키 → 숙소관리(공통).USER_SEQ — NOT NULL
  • LANG — varchar(10)
  • OPT_CD — varchar(10)

숙소유형 (SS_ROOM_TYPE)

  • TYPE_SEQ — number — 기본 키 — NOT NULL
  • USER_SEQ — number — 외래 키 → 숙소관리(공통).USER_SEQ — NOT NULL
  • LANG — varchar(10)
  • CODE — varchar(10)
  • COUNT — int
  • PEOPLE — int

숙소히스토리 (SS_ROOM_HISTORY)

  • HISTORY_SEQ — number — 기본 키
  • USER_SEQ — number — 외래 키 → 숙소관리(공통).USER_SEQ — NOT NULL
  • WRITER — varchar(20)
  • CONTENT — clob
  • RECEPT_DATE — date
  • SHIPMENT_DATE — date
  • STATE — varchar(10)

아이디 인증 (SS_AUTH_LOGIN)

  • USER_ID — varchar(100)
  • PHONE — varchar(13)
  • AUTH_DATE — date
  • AUTH_YN — varchar(10)
  • AUTH_TOKEN — varchar(6)

운영물품관리 (SS_OPER_GOODS)

  • GOODS_SEQ — number — 기본 키 — NOT NULL
  • USER_SEQ — number — 외래 키 → 회원관리.USER_SEQ — NOT NULL
  • USER_NAME — varchar(20)
  • POST_CODE — varchar(10)
  • ADRESS — varchar(100)
  • ADRESS2 — varchar(100)
  • PHONE — varchar(13)
  • EMAIL — varchar(100)
  • STATE — varchar(10)
  • GOODS_LIST — varchar(100)
  • RECEPT_DATE — date
  • SHIPMENT_DATE — date
  • YEAR — varchar(10)

코드 (SS_CODE)

  • CODE — varchar(10)
  • CODE_GROUP1 — varchar(10)
  • CODE_GROUP2 — varchar(10)
  • CODE_NM — varchar(45)
  • LANG — varchar(10)
  • USE_YN — varchar(10)

홍보물물품관리 (SS_PROMOTIONAL)

  • PROMOTE_SEQ — number — 기본 키 — NOT NULL
  • USER_SEQ — number — 외래 키 → 회원관리.USER_SEQ — NOT NULL
  • USER_NAME — varchar(20)
  • POST_CODE — varchar(10)
  • ADRESS — varchar(100)
  • ADRESS2 — varchar(100)
  • PHONE — varchar(13)
  • EMAIL — varchar(100)
  • STATE — varchar(10)
  • RECEPT_DATE — date
  • SHIPMENT_DATE — date
  • YEAR — varchar(10)

회원관리 (SS_MEMBER)

  • USER_SEQ — number — 기본 키 — NOT NULL
  • USER_ID — varchar(100)
  • USER_PW — varchar(100)
  • USER_NAME — varchar(20)
  • EMAIL — varchar(100)
  • PHONE — varchar(13)
  • BUISNESS_NUMBER — varchar(10)
  • DESIGNATION_DATE — date