miniShop

Tables (4)

authorities

  • u_id — NVARCHAR2(30) — Foreign key → users.u_id — NOT NULL
  • authority — NVARCHAR2(50) — NOT NULL

cart

  • p_id (Key) — NUMBER — Foreign key → product.Key — NOT NULL
  • name — NVARCHAR2(100)
  • brand — NVARCHAR2(100)
  • type — NVARCHAR2(100)
  • price — NUMBER
  • u_id — NVARCHAR2(30) — Foreign key → users.u_id — NOT NULL

product

  • Key — Primary key — NOT NULL
  • p_id — number
  • name — nvarchar2(100)
  • brand — nvarchar2(100)
  • type — nvarchar2(100)
  • price — number

users

  • u_id — NVARCHAR2(30) — Primary key — NOT NULL
  • u_pw — NVARCHAR2(60) — NOT NULL
  • u_nickname — NVARCHAR2(30)
  • u_name — NVARCHAR2(30)
  • u_gender — NVARCHAR2(30)
  • u_birthday — DATE
  • u_email — NVARCHAR2(30)
  • u_phoneNumber — NVARCHAR2(30)
  • u_address — NVARCHAR2(300)
  • u_joinDate — DATE — NOT NULL
  • u_profile_img — NVARCHAR2(50)
  • enabled — NUMBER(1) — NOT NULL