BR

Tables (11)

Copy Of Untitled (BR_Catelevel2)

  • Key (catelevel2_no) — NUMBER — Primary key — NOT NULL
  • Key (catelevel1_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (catelevel2_name) — VARCHAR2(30)

Untitled (BR_Admin)

  • Key (admin_no) — NUMBER — Primary key — NOT NULL
  • Field (admin_id) — VARCHAR2(20)
  • Field (admin_pw) — VARCHAR2(30)
  • Field (admin_phone) — VARCHAR2(20)
  • Field (admin_email) — VARCHAR2(50)
  • Field (admin_joindate) — DATE

Untitled (BR_Product)

  • Key (prod_no) — NUMBER — Primary key — NOT NULL
  • Key (admin_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (catelevel2_no) — NUMBER — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (prod_code) — VARCHAR2(20)
  • Field (prod_name) — VARCHAR2(50)
  • Field (prod_desc) — VARCHAR2(30)
  • Field (prod_stock_status) — VARCHAR(1)
  • Field (prod_date) — DATE

Untitled (BR_ProdImage)

  • Key (img_no) — NUMBER — Primary key — NOT NULL
  • Key (prod_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (img_url) — VARCHAR2(300)
  • Field (img_origin_filename) — VARCHAR2(400)

Untitled (BR_Catelevel1)

  • Key (catelevel1_no) — NUMBER — Primary key — NOT NULL
  • Field (catelevel1_name) — VARCHAR2(30)

Untitled (BR_ThumbImage)

  • Key (nail_no) — NUMBER — Primary key — NOT NULL
  • Key (prod_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (nail_url) — VARCHAR2(300)
  • Field (nail_origin_filename) — VARCHAR2(400)

Untitled (BR_User)

  • Key (user_no) — NUMBER — Primary key — NOT NULL
  • Field (user_id) — VARCHAR2(50)
  • Field (user_pw) — VARCHAR2(50)
  • Field (user_name) — VARCHAR2(50)
  • Field (user_phone) — VARCHAR2(20)
  • Field (user_email) — VARCHAR2(50)
  • Field (user_addr) — VARCHAE2(100)
  • Field (user_joindate) — DATE

Untitled (buy_option1)

  • Key (op1_no) — NUMBER — Primary key — NOT NULL
  • Field (name) — VARCHAR2(10)

Untitled (buy_option2)

  • Key (op2_no) — NUMBER — Primary key — NOT NULL
  • Key (op1_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR2(10)
  • Field (price) — NUMBER

Untitled (BR_Cart)

  • Key (cart_no) — NUMBER — Primary key — NOT NULL
  • Key (user_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (prod_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (op2_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (count) — NUMBER

Untitled (BR_Order)

  • Key (order_no) — NUMBER — Primary key — NOT NULL
  • Key (user_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (prod_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (op2_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (count) — NUMBER
  • Field (order_date) — DATE