ddasdf
Tables (10)
Address
- id — BIGINT — Primary key — NOT NULL
- userAddress — VARCHAR(100) — NOT NULL
- userId — BIGINT — NOT NULL
- zipcode — VARCHAR(10) — NOT NULL
- defaultAddress — BOOLEAN — NOT NULL
Administrator
- id — BIGINT — Primary key — NOT NULL
- adminName — VARCHAR(10) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(50) — NOT NULL
Cart
- id — BIGINT — Primary key — NOT NULL
- productId — BIGINT — NOT NULL
- userId — BIGINT — NOT NULL
- quantity — BIGINT — NOT NULL
Delivery
- id — BIGINT — Primary key — NOT NULL
- orderItemId — BIGINT — NOT NULL
- address — VARCHAR(100) — NOT NULL
- zipcode — VARCHAR(10) — NOT NULL
- phone — VARCHAR(15) — NOT NULL
- receiver — VARCHAR(15) — NOT NULL
- status — VARCHAR(10) — NOT NULL
OrderItem
- id — BIGINT — Primary key — NOT NULL
- orderId — BIGINT — NOT NULL
- productId — BIGINT — NOT NULL
- count — BIGINT — NOT NULL
- orderPrice — BIGINT — NOT NULL
- sellerId — BIGINT — NOT NULL
- status — VARCHAR(10) — NOT NULL
Orders
- id — BIGINT — Primary key — NOT NULL
- orderDate — DATETIME — NOT NULL
- userId — BIGINT — NOT NULL
- paymentId — BIGINT — NOT NULL
- totalPrice — BIGINT — NOT NULL
Payment
- id — BIGINT — Primary key — NOT NULL
- totalPrice — BIGINT — NOT NULL
- payMethod — VARCHAR(10) — NOT NULL
- payCompany — VARCHAR(20) — NOT NULL
Seller
- id — BIGINT — Primary key — NOT NULL
- sellerName — VARCHAR(50) — NOT NULL
- sellerNumber — VARCHAR(50) — NOT NULL
- address — VARCHAR(100) — NOT NULL
- phone — VARCHAR(15) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(20) — NOT NULL
Users
- id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(10) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(50) — NOT NULL
- phone — VARCHAR(15) — NOT NULL
product
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- detail — VARCHAR(3000) — NOT NULL
- sellerId — BIGINT — NOT NULL
- productPrice — BIGINT — NOT NULL
- thumbnail — VARCHAR(500) — NOT NULL
- stock — BIGINT — NOT NULL