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