capstone
Tables (6)
Order
- OrderId — LONG — Primary key — NOT NULL
- USERID — Long — Foreign key → User.USERID — NOT NULL
- currency — varchar
- quantity — int
- createdAt — DATE
- request — varchar
- OrderStatus — varchar
- paymentMethod — String
- productId — long
- Field
OrderDetail
- OrderDetailId — Long — Primary key — NOT NULL
- OrderId — LONG — Foreign key → Order.OrderId — NOT NULL
- USERID — Long — Foreign key → Order.USERID — NOT NULL
- productId — varchar — Foreign key → Product.productId — NOT NULL
- storeId (StoreId) — LONG — Foreign key → Product.storeId — NOT NULL
- productName — varchar
- ImageURL — String
- price — int
- address — varchar
- userName — String
- reciverName — varchar
- createAt — DATE
- storeName — String
- quantity — int
Product
- productId — varchar — Primary key — NOT NULL
- storeId (StoreId) — LONG — Foreign key → store.storeId — NOT NULL
- name — varchar
- imageURL — varchar
- price — int
- createdAt — DATE
- isSoldOut — boolean
- amount — int
- description — varchar
- discount — int
Shopping address DB
- addressId — Long — Primary key — NOT NULL
- USERID — Long — Foreign key → User.USERID — NOT NULL
- receiverName — varchar
- phoneNumber — varchar
- address — varchar
- postalCode — varchar
- country — varchar
- createdAt — DATE
User
- USERID — Long — Primary key — NOT NULL
- email — varchar
- createdAt — DATE
- name — varchar
- phoneNumber
store
- storeId (StoreId) — LONG — Primary key — NOT NULL
- name — String
- number — LONG