DesignSeller
Tables (15)
Category (category)
- Category Id (category_id) — BINARY(16) — Primary key — NOT NULL
- Category Id (parent_id) — BINARY(16) — Foreign key → Category.Category Id — NOT NULL
- Category Name (name) — VARCHAR(255)
Company (company)
- Company Id (company_id) — BINARY(16) — Primary key — NOT NULL
- Company Name (company_name) — VARCHAR(255)
Delivery (delivery)
- Delivery Id (delivery_id) — BINARY(16) — Primary key — NOT NULL
- City (city) — VARCHAR(255)
- Street (street) — VARCHAR(255)
- Zip Code (zipcode) — VARCHAR(255)
- Status (status) — TINYINT
Item (item)
- Item Id (item_id) — BINARY(16) — Primary key — NOT NULL
- Market Id (market_id) — BINARY(16) — Foreign key → Market.Market Id — NOT NULL
- Item Name (name) — VARCHAR(255)
Item Image (item_image)
- Item Image Id (item_image_id) — BINARY(16) — Primary key — NOT NULL
- Item Id (item_id) — BINARY(16) — Foreign key → Item.Item Id — NOT NULL
- Origin File Name (origin_file_name) — VARCHAR(255)
- Stored File Name (stored_file_name) — VARCHAR(255)
- File Size (file_size) — INT
- Created Date (created_date) — DATE
- Delete Check (delete_check) — TINYINT
- ThumbNail Check (thumbnail_check) — TINYINT
Item Option (item_option)
- Item Option Id (item_option_id) — BINARY(16) — Primary key — NOT NULL
- Item Id (item_id) — BINARY(16) — Foreign key → Item.Item Id — NOT NULL
- Option Stock Quantity (stock_quantity) — INT
- Option Price (price) — INT
Market (market)
- Market Id (market_id) — BINARY(16) — Primary key — NOT NULL
- Member Id (member_id) — BINARY(16) — Foreign key → Member.Member Id — NOT NULL
- Market Name (name) — VARCHAR(255)
- Market Description (description) — TEXT
- Created Date (createdAt) — DATE
- Updated Date (updatedAt) — DATE
Member (member)
- Member Id (member_id) — BINARY(16) — Primary key — NOT NULL
- Member Name (name) — VARCHAR(255)
- Email (email) — VARCHAR(255)
- Password (password) — VARCHAR(255)
- City (city) — VARCHAR(255)
- Street (street) — VARCHAR(255)
- Zip Code (zipcode) — VARCHAR(255)
- Created Date (createdAt) — DATE
- Updated Date (updatedAt) — DATE
- Delete Check (delete_check) — TINYINT
Order (orders)
- Order Id (order_id) — BINARY(16) — Primary key — NOT NULL
- Member Id (member_id) — BINARY(16) — Foreign key → Member.Member Id — NOT NULL
- Delivery Id (delivery_id) — BINARY(16) — Foreign key → Delivery.Delivery Id — NOT NULL
- Order Date (createdAt) — DATE
- Status (status) — TINYINT
OrderItem (order_item)
- Order Item Id (order_item_id) — BINARY(16) — Primary key — NOT NULL
- Order Id (order_id) — BINARY(16) — Foreign key → Order.Order Id — NOT NULL
- Item Option Id (item_option_id) — BINARY(16) — Foreign key → Item Option.Item Option Id — NOT NULL
- Count (count) — INT
- Order Price (order_price) — INT
Production (production)
- Production Id (production_id) — BINARY(16) — Primary key — NOT NULL
- Company Id (company_id) — BINARY(16) — Foreign key → Company.Company Id — NOT NULL
- Category Id (category_id) — BINARY(16) — Foreign key → Category.Category Id — NOT NULL
- Production Name (name) — VARCHAR(255)
- Production Price (price) — INT
- Production Like (likes) — INT
- Production Thumbnail_Image (thumbnail_image) — VARCHAR(255)
- Production View (view) — INT
Production Image (production_image)
- Production Image Id (production_image_id) — BINARY(16) — Primary key — NOT NULL
- Production Id (production_id) — BINARY(16) — Foreign key → Production.Production Id — NOT NULL
- Production Image Name (name) — VARCHAR(255)
Production Option (production_option)
- Production Option id (production_option_id) — BINARY(16) — Primary key — NOT NULL
- Production Id (production_id) — BINARY(16) — Foreign key → Production.Production Id — NOT NULL
- Option Name (name) — VARCHAR(255)
- Field
Production Request (production_request)
- Key (production_request_id) — BINARY(16) — Primary key — NOT NULL
- Key (request_id) — BINARY(16) — Foreign key → Request.Key — NOT NULL
- Production Option id (production_option_id) — BINARY(16) — Foreign key → Production Option.Production Option id — NOT NULL
- Count (count) — INT
- Request Price (request_price) — INT
Request (request)
- Key (request_id) — BINARY(16) — Primary key — NOT NULL
- Market Id (market_id) — BINARY(16) — Foreign key → Market.Market Id — NOT NULL
- Create Date (create_date) — DATE
- Update Date (update_date) — Date
- Total Price (total_price) — INT
- Street (street) — VARCHAR(255)
- ZIPCODE (zipcode) — VARCHAR(255)
- Detail — VARCHAR(255)
- Requester Name (requester_name) — VARCHAR(255)
- Requester Email (email) — VARCHAR(255)
- Requester Phone (phone) — VARCHAR(255)
- Request Status (status) — TINYINT