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