미니프로젝트 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