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)