MU ERD

맨유 쇼핑몰 ERD

테이블 (12)

Brands

  • BrandID (brand_id) — CHAR(4) — 기본 키 — NOT NULL
  • Brand name (brand_name) — VARCHAR(100) — NOT NULL

Code

  • codeID (code_id) — CHAR(4) — 기본 키 — NOT NULL
  • code name (code_name) — VARCHAR(100) — NOT NULL
  • is code avaliable (is_code_available) — TINYINT(1)
  • discount amount (discount_amount) — DECIMAL(5,2)

Images (images)

  • imagesID (images_id) — CHAR(4) — 기본 키 — NOT NULL
  • is thumbnail (is_thumbnail) — TINYINT(1)
  • image url (image_url) — VARCHAR(100) — NOT NULL

Main Category

  • Main Category ID (main_category_id) — CHAR(4) — 기본 키 — NOT NULL
  • main category name (main_category_name) — VARCHAR(100) — NOT NULL

Mid Table of Product and SubCategory (mid table)

  • mid of product and sub category ID (sub_category_id) — CHAR(4) — 기본 키 — NOT NULL
  • ProductID (product_id) — CHAR(4) — 외래 키 → Products.ProductID — NOT NULL
  • Sub Category ID (sub_category_id2) — CHAR(4) — 외래 키 → Sub Category.Sub Category ID — NOT NULL

Personalisation

  • PersonalisationID (personalisation_id) — CHAR(4) — 기본 키 — NOT NULL
  • Personalisation available (is_personalisationable) — TINYINT(1)
  • arm badge (arm_badge) — VARCHAR(100)
  • custom contents — VARCHAR(100)

Players

  • PlayersID (Players_id) — CHAR(4) — 기본 키 — NOT NULL
  • players name (players_name) — VARCHAR(100) — NOT NULL

Products (products)

  • ProductID (product_id) — CHAR(4) — 기본 키 — NOT NULL
  • imagesID (images_id2) — CHAR(4) — 외래 키 → Images.imagesID — NOT NULL
  • PersonalisationID (personalisation_id) — CHAR(4) — 외래 키 → Personalisation.PersonalisationID — NOT NULL
  • PlayersID (Players_id) — CHAR(4) — 외래 키 → Players.PlayersID — NOT NULL
  • BrandID (brand_id) — CHAR(4) — 외래 키 → Brands.BrandID — NOT NULL
  • Product name (product_name) — VARCHAR(100)
  • Shipping description (shipping) — TEXT — NOT NULL
  • Product description (description) — TEXT — NOT NULL
  • Price (price) — DECIMAL(10,4)
  • Stock (stock) — DECIMAL(10)
  • quantity — DECIMAL(10)
  • size (sizes) — VARCHAR(100) — NOT NULL

Sub Category

  • Sub Category ID (sub_category_id) — CHAR(4) — 기본 키 — NOT NULL
  • Main Category ID (main_category_id) — CHAR(4) — 외래 키 → Main Category.Main Category ID — NOT NULL
  • sub category name (sub_category_name) — VARCHAR(100)

order (Untitled2)

  • orderid (Key) — CHAR(4) — 기본 키 — NOT NULL
  • userID (Key2) — CHAR(4) — 외래 키 → user.userID — NOT NULL
  • ProductID (product_id) — CHAR(4) — 외래 키 → Products.ProductID — NOT NULL
  • status (Field) — enum

point (Untitled3)

  • pointID (Key) — CHAR(4) — 기본 키 — NOT NULL
  • userID (Key2) — CHAR(4) — 외래 키 → user.userID — NOT NULL
  • impUid (Field)
  • amount (Field2)
  • status (Field3)
  • createdAt (Field5)

user (Untitled)

  • userID (Key) — CHAR(4) — 기본 키 — NOT NULL
  • email (Field)
  • password (Field2)
  • age (Field3)
  • name (Field4)
  • point (Field5)