선착순구매

테이블 (12)

BOOK

  • Key — NUMBER — 기본 키 — NOT NULL
  • RES_NO — NUMBER — 외래 키 → RESTAURANTS.RES_NO — NOT NULL
  • USER_NO — NUMBER — 외래 키 → user.USER_NO — NOT NULL
  • book_type — VARCHAR2(32)
  • people — VARCHAR2(32)
  • request — VARCHAR2(1000)
  • book_hours — VARCHAR2
  • state — number
  • book_date — VARCHAR2

COMMENTS

  • comment_no — NUMBER — 기본 키 — NOT NULL
  • review_no2 — NUMBER — 외래 키 → REVIEW.review_no — NOT NULL
  • content — VARCHAR2(32)
  • writer — VARCHAR2(1000)
  • create_date — VARCHAR(255)

NOTICE

  • notice_no — NUMBER — 기본 키 — NOT NULL
  • writer — VARCHAR2(32)
  • title — VARCHAR2(100)
  • content — VARCHAR2(2000)
  • hit — NUMBER(LONG)
  • reg_date — Date
  • lastmodified — Date

PAY

  • pay_no — NUMBER — 기본 키 — NOT NULL
  • USER_NO — NUMBER — 외래 키 → user.USER_NO — NOT NULL
  • RES_NO — NUMBER — 외래 키 → RESTAURANTS.RES_NO — NOT NULL
  • pay_date — VARCHAR2(50)
  • pay_name — VARCHAR2(32)
  • pay_method — VARCHAR2(32)
  • amount — NUMBER

Q&A

  • q_no — NUMBER — 기본 키 — NOT NULL
  • writer — VARCHAR2(32)
  • title — VARCHAR2(32)
  • content — VARCHAR2(2000)
  • hit — NUMBER
  • reg_date — DATE
  • lastmodified — DATE

RESTAURANTS

  • RES_NO — NUMBER — 기본 키 — NOT NULL
  • o_no — NUMBER — 외래 키 → owner.o_no — NOT NULL
  • res_name — VARCHAR2(32)
  • res_loc — VARCHAR2(100)
  • res_hours — varchar
  • tel — VARCHAR2(13)
  • reg_date — DATE
  • origin — VARCHAR2(300)
  • saved — VARCHAR2(300)
  • path — VARCHAR2(300)
  • res_detail — VARCHAR2(2000)
  • state — NUMBER

REVIEW

  • review_no — NUMBER — 기본 키 — NOT NULL
  • USER_NO — NUMBER — 외래 키 → user.USER_NO — NOT NULL
  • RES_NO — NUMBER — 외래 키 → RESTAURANTS.RES_NO — NOT NULL
  • writer — VARCHAR2(32)
  • content — VARCHAR2(2000)
  • rate — VARCHAR(255)
  • origin — VARCHAR2(300 NULL, `saved` VARCHAR2(300)
  • path — VARCHAR2(300)
  • review_date — date

Reply

  • reply_no — NUMBER — 기본 키 — NOT NULL
  • notice_no — NUMBER — 외래 키 → NOTICE.notice_no — NOT NULL
  • review_no — NUMBER — 외래 키 → REVIEW.review_no — NOT NULL
  • writer — VARCHAR2(32)
  • title — VARCHAR2(100)
  • content — VARCHAR2(2000)
  • reg_date — Date

UPLOADFILE

  • uuid — VARCHAR2(100) — 기본 키 — NOT NULL
  • path — VARCHAR2(100)
  • origin — VARCHAR2(100)
  • res_no — NUMBER

User_Log

  • log_no — NUMBER — 기본 키 — NOT NULL
  • USER_NO — NUMBER — 외래 키 → user.USER_NO — NOT NULL
  • Login_Date — Date

owner

  • o_no — NUMBER — 기본 키 — NOT NULL
  • o_id — VARCHAR2(32)
  • o_pw — VARCHAR2(32)
  • o_email — VARCHAR2(100)
  • o_tel — VARCHAR2(13)
  • o_name — VARCHAR2(32)
  • state — NUMBER

user

  • USER_NO — NUMBER — 기본 키 — NOT NULL
  • user_id — VARCHAR2(32)
  • user_pw — VARCHAR2(32)
  • user_name — VARCHAR2(50)
  • user_tel — VARCHAR2(13)
  • user_grade — VARCHAR2(6)
  • userd_date — DATE
  • birthday — VARCHAR2(10)
  • state. — NUMBER(1)
  • point — NUMBER(4)
  • ad_no — VARCHAR2(100)
  • ad_id — VARCHAR2(32)
  • ad_pw — VARCHAR2(32)
  • user_email — VARCHAR2(100)