미니프로젝트 1조
테이블 (9)
Untitled (user_table)
- Key (user_id) — varchar2(50) — 기본 키 — NOT NULL
- Field (pwd) — varchar2(1000)
- Field2 (name) — varchar2(50)
- Field (tel) — varchar2(30)
- Field3 (level) — number
- Field (addr) — varchar2(200)
Untitled (reviews_table)
- Key (rest_id) — number — 외래 키 → Untitled2.Key — NOT NULL
- Key (user_Id) — varchar2(50) — 외래 키 → Untitled.Key — NOT NULL
- Field (grade) — number
- Field (content) — varchar2(600)
- Field (created_date) — date
Untitled (board_table)
- Key (nid) — number — 기본 키 — NOT NULL
- Key (user_Id) — varchar2(50) — 외래 키 → Untitled.Key — NOT NULL
- Field (title) — varchar2(100)
- Field (content) — varchar2(4000)
- Field (created_date) — date
- Field (updated_date) — date
- Field (hit) — number
- Field (norb) — varchar2(1)
Untitled (event_table)
- Key (eid) — number — 기본 키 — NOT NULL
- Key (rest_id) — number — 외래 키 → Untitled2.Key — NOT NULL
- Key (item_id) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (persentage) — number
- Field (start_date) — date
- Field (end_date) — date
Untitled (orderlist)
- Key (user_Id) — varchar2(50) — 외래 키 → Untitled.Key — NOT NULL
- Key (rest_id) — number — 외래 키 → Untitled3.Key — NOT NULL
- Key (item_id) — number — 외래 키 → Untitled3.Key — NOT NULL
- Field (check) — number
- Field (order_date) — date
- Field (item_cnt) — number
Untitled (item_table)
- Key (item_id) — number — 기본 키 — NOT NULL
- Field (item_name) — varchar2(50)
- Field (price) — number
- Field (img_location) — varchar2(100)
- Field (item_cnt) — number
Untitled2 (rest_table)
- Key (rest_id) — number — 기본 키 — NOT NULL
- Key (user_Id) — varchar2(50) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — varchar2(50)
- Field (addr) — varchar2(150)
Untitled3 (salelist)
- Key (rest_id) — number — 외래 키 → Untitled2.Key — NOT NULL
- Key (item_id) — number — 외래 키 → Untitled.Key — NOT NULL
test (comment_table)
- Key (nid) — number — 외래 키 → Untitled.Key — NOT NULL
- Key (user_Id) — varchar2(50) — 외래 키 → Untitled.Key — NOT NULL
- Field (content) — varchar2(1000)
- Field (created_date) — date
- Field (updated_date) — date
- Field (level) — number
- Field (base_nid) — number
- Field (board_id) — number