Goodz
Tables (18)
authentication
- authID — INT
- productID — INT
- authStatus — ENUM('pending', 'verified', 'rejected') — NOT NULL
- authDate — DATETIME
autologin
- autoLoginID — INT
- userID — INT
- token — VARCHAR(255)
- expirationDate — DATETIME
- createdAt — DATETIME
comment
- commentID — INT
- postID — INT
- userID — INT
- commentText — TEXT
- createdAt — DATETIME
follow
- followID — INT
- followerID — INT
- followingID — INT
- createdAt — DATETIME
like
- likeID — INT
- postID — INT
- userID — INT
- createdAt — DATETIME
order
- id — INT
- userID — INT
- orderDate — DATETIME
- totalAmount — DECIMAL(10, 2) — NOT NULL
- orderStatus — ENUM('pending', 'shipped', 'delivered', 'cancelled') — NOT NULL
orderitem
- orderItemID — INT
- orderID — INT
- productID — INT
- quantity — INT — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
payment
- paymentID — INT
- orderID — INT
- paymentDate — DATETIME
- paymentAmount — DECIMAL(10, 2) — NOT NULL
- paymentMethod — VARCHAR(50)
post
- postID — INT
- userID — INT
- content — TEXT
- imageURL — VARCHAR(255)
- createdAt — DATETIME
pricehistory
- priceHistoryID — INT
- productID — INT
- price — DECIMAL(10, 2) — NOT NULL
- startDate — DATETIME
- endDate — DATETIME
product
- Key — VARCHAR(100) — Primary key — NOT NULL
- productName — VARCHAR(100) — NOT NULL
- description — TEXT
- brand — VARCHAR(50)
- category — VARCHAR(50)
- price — DECIMAL(10, 2) — NOT NULL
- stockQuantity — INT — NOT NULL
- imageURL — VARCHAR(255)
- createdAt — DATETIME
rememberme
- rememberMeID — INT
- userID — INT
- token — VARCHAR(255)
- expirationDate — DATETIME
- createdAt — DATETIME
review
- reviewID — INT
- userID — INT
- productID — INT
- rating — INT
- comment — TEXT — EX
- reviewDate — DATETIME
shipment
- shipmentID — INT
- orderID — INT
- shippingAddress — VARCHAR(255)
- shippingMethod — VARCHAR(50)
- trackingNumber — VARCHAR(50)
- shipmentStatus — ENUM('pending', 'shipped', 'in_transit', 'delivered', 'returned') — NOT NULL
- shippedDate — DATETIME
- estimatedDeliveryDate — DATETIME
- deliveredDate — DATETIME
shippingaddress
- addressID — INT
- userID — INT
- recipientName — VARCHAR(100)
- streetAddress — VARCHAR(255)
- city — VARCHAR(100)
- state — VARCHAR(100)
- zipCode — VARCHAR(20)
- country — VARCHAR(50)
- phoneNumber — VARCHAR(20)
- isDefault — BOOLEAN
sociallogin
- socialLoginID — INT
- userID — INT
- provider — VARCHAR(50)
- providerUserID — VARCHAR(100)
- createdAt — DATETIME
user
- userID — VARCHAR(255) — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phoneNumber — VARCHAR(20)
- role — ENUM('admin, 'user') — NOT NULL
- dateJoined — DATETIME
- profilePictureURL — VARCHAR(255)
- bio (일단 보류) (bio) — TEXT
wishlist
- wishlistID — INT
- userID — INT
- productID — INT
- addedDate — DATETIME