ShinaNanDa

Tables (15)

Copy Of Untitled (SN_Brand_Category)

  • Key (brand_no) — NUMBER — Primary key — NOT NULL
  • Field (brand_name) — VARCHAR2(100)

Untitled (SN_Member)

  • Key (member_no) — NUMBER — Primary key — NOT NULL
  • Field (member_name) — VARCHAR2(20)
  • Field (member_id) — VARCHAR2(20)
  • Field (member_pw) — VARCHAR2(400)
  • Field (member_nick) — VARCHAR2(20)
  • Field (member_gender) — VARCHAR2(1)
  • Field (member_birth) — DATE
  • Field (member_phone) — VARCHAR2(20)
  • Field (member_address) — VARCHAR2(1000)
  • Field (member_email) — VARCHAR2(100)
  • Field (member_joindate) — DATE

Untitled (SN_Product)

  • Key (product_no) — NUMBER — Primary key — NOT NULL
  • Key (product_category_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (brand_no) — NUMBER — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (product_title) — VARCHAR2(50)
  • Field (product_model) — VARCHAR2(50)
  • Field (product_price) — NUMBER
  • Field (product_date) — DATE
  • Field (product_image) — VARCHAR2(500)

Untitled (SN_Product_Category)

  • Key (product_category_no) — NUMBER — Primary key — NOT NULL
  • Field (product_category_name) — VARCHAR2(45)

Untitled (SN_Image)

  • Key (image_no) — NUMBER — Primary key — NOT NULL
  • Key (product_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (image_url) — VARCHAR2(4000)

Untitled (SN_Product_Detail)

  • Key (product_detail_no) — NUMBER — Primary key — NOT NULL
  • Key (product_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (product_detail_color) — VARCHAR2(45)
  • Field (product_detail_size) — VARCHAR2(45)
  • Field (product_detail_stock) — NUMBER

Untitled (SN_Cart)

  • Key (cart_no) — NUMBER — Primary key — NOT NULL
  • Key (product_detail_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (cart_count) — NUMBER

Untitled (SN_Orders)

  • Key (orders_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (orders_total_price) — NUMBER
  • Field (orders_state) — VARCHAR2(45)
  • Field (orders_date) — DATE
  • Field (orders_address) — VARCHAR2(1000)

Untitled (SN_Orders_Detail)

  • Key (orders_detail_no) — NUMBER — Primary key — NOT NULL
  • Key (orders_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (product_detail_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (orders_detail_count) — NUMBER
  • Field (orders_detail_price) — NUMBER

Untitled (SN_Payment)

  • Key (payment_no) — NUMBER — Primary key — NOT NULL
  • Key (payment_method_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (orders_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (payment_date) — DATE

Untitled (SN_Payment_Method)

  • Key (payment_method_no) — NUMBER — Primary key — NOT NULL
  • Field (payment_method_name) — VARCHAR2(45)

Untitled (SN_Bank_Category)

  • Key (bank_category_no) — NUMBER — Primary key — NOT NULL
  • Field (bank_category_name) — VARCHAR2(45)
  • Field (bank_category_account) — VARCHAR2(100)

Untitled (SN_Payment_Bank_Info)

  • Key (payment_bank_info_no) — NUMBER — Primary key — NOT NULL
  • Key (bank_category_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (payment_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (payment_bank_info_depositor) — VARCHAR2(45)

Untitled (SN_Card_Category)

  • Key (card_category_no) — NUMBER — Primary key — NOT NULL
  • Field (card_category_company_name) — VARCHAR2(45)

Untitled (SN_Payment_Card_Info)

  • Key (payment_card_info_no) — NUMBER — Primary key — NOT NULL
  • Key (card_category_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (payment_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL