선착순구매
테이블 (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)