Project1

테이블 (26)

QNA 테이블 (THISQNA)

  • QNA_NO — NUMBER — 기본 키 — NOT NULL
  • M_NO — NUMBER — NOT NULL
  • QNA_TYPE — NUMBER
  • QNA_QUESTION — VARCHAR2(300)
  • QNA_ANSWER — VARCHAR2(1000)
  • QNA_FLAG — CHAR(1)
  • QNA_FILE — VARCHAR2(300)

객실 테이블 (TMSTROOM)

  • R_NO — NUMBER — 기본 키 — NOT NULL
  • S_NO — NUMBER — NOT NULL
  • R_NAME — VARCHAR2(100)
  • R_DETAIL — VARCHAR2(500)
  • R_PERSON_CNT — NUMBER
  • R_PRICE — NUMBER
  • R_IMG1 — VARCHAR2(300)
  • R_IMG2 — VARCHAR2(300)
  • R_IMG3 — VARCHAR2(300)
  • R_SINGLE_BED_FLAG — CHAR(1)
  • R_DOUBLE_BED_FLAG — CHAR(1)
  • R_QUEEN_BED_FLAG — CHAR(1)
  • R_FACILITY1 — NUMBER
  • R_FACILITY2 — NUMBER
  • R_FACILITY3 — NUMBER
  • R_FACILITY4 — NUMBER
  • R_FACILITY5 — NUMBER
  • R_FACILITY6 — NUMBER

경품 배송 내역 관리 (THISDELIVERY)

  • DELIVERY_NO — NUMBER — 기본 키 — NOT NULL
  • EVENT_NO — NUMBER — NOT NULL
  • ITEM_NO — NUMBER — NOT NULL
  • M_NO — NUMBER — NOT NULL
  • DELIVERY_ADDR — VARCHAR2(1000)
  • STEP_FLAG — NUMBER
  • EVENT_DATE — TIMESTAMP
  • STEP1_DATE — TIMESTAMP
  • STEP2_DATE — TIMESTAMP
  • STEP3_DATE — TIMESTAMP

경품 테이블 (TMSTITEM)

  • EVENT_NO — NUMBER — 기본 키 — NOT NULL
  • ITEM_NO — NUMBER — 기본 키 — NOT NULL
  • ITEM_NAME — VARCHAR2(300)
  • ITEM_DESC — VARCHAR2(1000)
  • FILENAME — VARCHAR2(300)

기준정보 그룹 테이블 (TMSTCODEGRP)

  • GRP_CODE — NUMBER — 기본 키 — NOT NULL
  • GRP_CODENAME — VARCHAR2(100)

기준정보 상세 테이블 (TMSTCODE)

  • GRPCODE — NUMBER — 기본 키 — NOT NULL
  • CODE — NUMBER — 기본 키 — NOT NULL
  • CODENAME — VARCHAR2(500)

문의 테이블 (THISINQUERY)

  • QNA_NO — NUMBER — 기본 키 — NOT NULL
  • M_NO — NUMBER — NOT NULL
  • INQUERY_TYPE — NUMBER
  • INQUERY_QUESTION — VARCHAR2(300)
  • INQUERY_QUESTION_DATE — TIMESTAMP
  • INQUERY_ANSWER — VARCHAR2(1000)
  • INQUERY_ANSWER_DATE — TIMESTAMP
  • INQUERY_FLAG — CHAR(1)
  • REVIEW_GROUP — NUMBER
  • INQUERY_STEP — NUMBER

사용자 테이블 (TMSTMEMBER)

  • M_NO — NUMBER — 기본 키 — NOT NULL
  • M_EMAIL — VARCHAR2(50)
  • M_PW — VARCHAR2(200)
  • M_NAME — VARCHAR2(20)
  • M_TEL — VARCHAR(30)
  • M_SEC — NUMBER
  • M_POINT — NUMBER
  • M_ROADADDRESS — VARCHAR2(1000)
  • M_DETAIL_ADDRESS — VARCHAR2(2000)
  • M_MARKETING — CHAR(1)
  • M_AREA1 — NUMBER
  • M_AREA2 — NUMBER
  • M_AREA3 — NUMBER
  • M_THEME1 — NUMBER
  • M_THEME2 — NUMBER
  • M_THEME3 — NUMBER
  • M_LOCK — CHAR(1)
  • M_EMAILCHECK — CHAR(1)

사용자 후기 테이블 (THISREVIEW)

  • REVIEW_NO — NUMBER — 기본 키 — NOT NULL
  • M_NO — NUMBER
  • S_NO — NUMBER
  • R_NO — NUMBER
  • PHOTO_URL — VARCHAR2(300)
  • REVIEW_RATE — NUMBER
  • LIKES — NUMBER
  • REVIEW_CONTENT — VARCHAR2(1000)
  • REVIEW_DATE — TIMESTAMP
  • REVIEW_GROUP — NUMBER
  • REVIEW_STEP — NUMBER
  • RESTRICT_FLAG — CHAR(1)
  • REPORT_NO — NUMBER — NOT NULL

상위 메뉴 테이블 (TMSTMENU)

  • MENU_SEQ — NUMBER — 기본 키 — NOT NULL
  • MENU_NO — NUMBER — 기본 키 — NOT NULL
  • MENU_NAME — VARCHAR2(100)
  • MENU_FLAG — CHAR(1)

숙소 결제 / 예약 상세 내역 (THISORDERDTL)

  • ORDER_NO — NUMBER — NOT NULL
  • S_NO — NUMBER — NOT NULL
  • R_NO — NUMBER — NOT NULL

숙소 테이블 (TMSTSTAY)

  • S_NO — NUMBER — 기본 키 — NOT NULL
  • S_NAME — VARCHAR2(100)
  • S_TYPE — NUMBER
  • S_INFO — VARCHAR2(3000)
  • S_LOCA — NUMBER
  • S_ADDR_X — VARCHAR2(100)
  • S_ADDR_Y — VARCHAR2(100)
  • S_IMG1 — VARCHAR2(300)
  • S_IMG2 — VARCHAR2(300)
  • S_IMG3 — VARCHAR2(300)
  • S_ADDR — VARCHAR2(1000)
  • S_FACILITY1 — NUMBER
  • S_FACILITY2 — NUMBER
  • S_FACILITY3 — NUMBER
  • S_FACILITY4 — NUMBER
  • S_FACILITY5 — NUMBER
  • S_FACILITY6 — NUMBER
  • S_THEME1 — NUMBER
  • S_THEME2 — NUMBER
  • S_THEME3 — NUMBER
  • S_THEME4 — NUMBER
  • S_THEME5 — NUMBER
  • S_THEME6 — NUMBER
  • S_THEME7 — NUMBER
  • S_THEME8 — NUMBER
  • S_RATE — NUMBER(1,1)

신고 테이블 (THISREPORT)

  • REPORT_NO — NUMBER — 기본 키 — NOT NULL
  • REPORT_TYPE — NUMBER
  • REPORT_CONTENT — VARCHAR(3000)
  • REPORT_DATE — TIMESTAMP

알림 테이블 (THISPUSHAL)

  • AL_NO — NUMBER — 기본 키 — NOT NULL
  • M_NO — NUMBER — 기본 키 — NOT NULL
  • AL_CONTENT — VARCHAR(1000)
  • AL_GUBUN — NUMBER
  • ORDER_NO — NUMBER
  • DELIVERY_NO — NUMBER
  • AL_TIME — TIMESTAMP

이벤트 참여 테이블 (THISATTEND)

  • EVENT_NO — NUMBER — 기본 키 — NOT NULL
  • M_NO — NUMBER — 기본 키 — NOT NULL

이벤트 테이블 (TMSTEVENT)

  • EVENT_NO — NUMBER — 기본 키 — NOT NULL
  • EVENT_NAME — VARCHAR2(300)
  • EVENT_INTRO — VARCHAR(3000)
  • EVENT_CONTENT — VARCHAR(3000)
  • EVENT_STARTDATE — TIMESTAMP
  • EVENT_ENDDATE — TIMESTAMP
  • EVENT_TARGET — VARCHAR(3000)
  • EVENT_CAUTION — VARCHAR(3000)
  • EVENT_FLAG — NUMBER
  • FILENAME — VARCHAR2(300)
  • FILENAME2 — VARCHAR2(300)
  • EVENT_MEMBER_FLAG — CHAR(1)
  • M_NO1 — NUMBER
  • M_NO2 — NUMBER
  • M_NO3 — NUMBER

장바구니 테이블 (THISCART)

  • M_NO — NUMBER — 기본 키 — NOT NULL
  • S_NO — NUMBER — 기본 키 — NOT NULL
  • R_NO — NUMBER — 기본 키 — NOT NULL

좋아요 테이블 (THISLIKE)

  • REVIEW_ID — NUMBER — 기본 키 — NOT NULL
  • M_NO — NUMBER — NOT NULL

주문 테이블 (THISORDER)

  • ORDER_NO — NUMBER — 기본 키 — NOT NULL
  • M_NO — NUMBER — NOT NULL
  • S_NO — NUMBER
  • COUPON_NO — NUMBER
  • ORDER_DATE — TIMESTAMP
  • TOTAL_PRICE — NUMBER
  • DISCOUNT_PRICE — NUMBER
  • PAYMENT_PRICE — NUMBER
  • PAYMENT_METHOD — NUMBER
  • PAYMENT_CARDNO — VARCHAR2(1000)
  • PAYMENT_ACCOUNT — VARCHAR2(1000)
  • PAYMENT_FLAG — CHAR(1)
  • HOT_DEAL_FLAG — CHAR(1)
  • CHECK_IN_DATE — TIMESTAMP
  • CHECK_OUT_DATE — TIMESTAMP
  • REVIEW_FLAG — CHAR(1)

쿠폰 보유 테이블 (THISCOUPON)

  • M_NO — NUMBER — 기본 키 — NOT NULL
  • COUPON_NO — NUMBER — 기본 키 — NOT NULL
  • COUPON_QTY — NUMBER

쿠폰 사용 테이블 (THISUSECOUPON)

  • COUPON_NO — NUMBER — 기본 키 — NOT NULL
  • M_NO — NUMBER — 기본 키 — NOT NULL
  • COUPON_USEFLAG — CHAR(1)
  • COUPON_DATE — TIMESTAMP
  • COUPON_USEDATE — TIMESTAMP

쿠폰 테이블 (TMSTCOUPON)

  • COUPON_NO — NUMBER — 기본 키 — NOT NULL
  • COUPON_DETAIL — VARCHAR2(300)
  • COUPON_FLAG — CHAR(1)
  • COUPON_QTY — NUMBER

포인트 테이블 (THISPOINT)

  • POINT_NO — NUMBER — 기본 키 — NOT NULL
  • M_NO — NUMBER — NOT NULL
  • ORDER_NO — NUMBER
  • POINT_TYPE — NUMBER
  • POINT_IN — NUMBER
  • POINT_OUT — NUMBER
  • POINT_USEDATE — TIMESTAMP

하위 메뉴 테이블 (TMSTMENUDTL)

  • SUB_MENU_NO — NUMBER — 기본 키 — NOT NULL
  • MENU_SEQ — NUMBER — NOT NULL
  • MENU_NO — NUMBER — NOT NULL
  • SUB_MENU_NAME — VARCHAR2(500)
  • SUB_MENU_LINK — VARCHAR2(1000)
  • SUB_MENU_FLAG — CHAR(1)

할인 테이블 (TMSTDEAL)

  • DEAL_NO — NUMBER — 기본 키 — NOT NULL
  • S_NO — NUMBER
  • DEAL_START_DATE — TIMESTAMP
  • DEAL_END_DATE — TIMESTAMP
  • DEAL_STATUS — NUMBER
  • DEAL_DISCOUNT — NUMBER

환불 테이블 (THISREFUND)

  • REFUND_NO — NUMBER — 기본 키 — NOT NULL
  • ORDER_NO — NUMBER — NOT NULL
  • REFUND_REASON — NUMBER
  • REFUND_PRICE — NUMBER
  • REFUND_PERCENTAGE — NUMBER(3,1)
  • STEP_FLAG — NUMBER
  • STEP1_DATE — TIMESTAMP
  • STEP2_DATE — TIMESTAMP