미츠노이브 관련
테이블 (6)
order
- id — UUID — 기본 키 — NOT NULL
- email — VARCHAR(30) — 외래 키 → user.email — NOT NULL
- productId — UUID — 외래 키 → product.id — NOT NULL
- requestSize — FLOAT — NOT NULL
- serialId — VARCHAR(90) — NOT NULL
- progress — INT — NOT NULL
- createdAt — DATETIME — NOT NULL
product
- id — UUID — 기본 키 — NOT NULL
- name — VARCHAR(90) — NOT NULL
- price — VARCHAR(90) — NOT NULL
- frontThumbnail — VARCHAR(90) — NOT NULL
- backThumbnail — VARCHAR(90) — NOT NULL
- sideThumbnail — VARCHAR(90) — NOT NULL
- description — TEXT — NOT NULL
- detailVideo — VARCHAR(90) — NOT NULL
- createdAt — DATETIME — NOT NULL
product_material
- id — UUID — NOT NULL
- material — VARCHAR(30) — NOT NULL
- content — VARCHAR(30) — NOT NULL
user
- email — VARCHAR(30) — 기본 키 — NOT NULL
- password — VARCHAR(100) — NOT NULL
- name — VARCHAR(30) — NOT NULL
- location — VARCHAR(100)
- phone — VARCHAR(30)
- createdAt — DATETIME — NOT NULL
- latest — DATETIME
user_account
- account — VARCHAR(30) — 기본 키 — NOT NULL
- email — VARCHAR(30) — NOT NULL
- bank — VARCHAR(30) — NOT NULL
user_body_measurement
- email — VARCHAR(30) — 외래 키 → user.email — NOT NULL
- neck — FLOAT
- leftThumb — FLOAT
- leftFore — FLOAT
- leftMiddle — FLOAT
- leftRing — FLOAT
- leftLittle — FLOAT
- rightThumb — FLOAT
- rightFore — FLOAT
- rightMiddle — FLOAT
- rightRing — FLOAT
- rightLittle — FLOAT
- leftArm — FLOAT
- rightArm — FLOAT
- leftCarpus — FLOAT
- rightCarpus — FLOAT