Naily(26.8.31.)
Tables (12)
Untitled (hand_scans)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (status) — varchar(20)
- Field (hand_side) — varchar(10)
- Field (finger_name) — enum('thumb', 'index', 'middle', 'ring', 'pinky'
- Field (scanned_at) — DATETIME
- Key (print_order_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_id2) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (hand_scan_analysis)
- Key (id) — bigint — Primary key — NOT NULL
- Key (scan_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (nail_length_mm) — float
- Field (nail_width_mm) — float
- Field (nail_curvature) — float
- Field (created_at) — DATETIME
- Field (skin_tone_hex) — varchar(10)
- Field (tone) — varchar(10)
- Field (warmness) — couble
- Field (brightness) — double
- Field (saturation) — double
- Field (recommended_colors) — JSON
- Field (recommended_shape) — varchar(50)
- Field (analyzed_at) — DATETIME
Untitled (print_orders)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (shape_id) — varchar(50)
- Field (shape_label_ko) — varchar(50)
- Field (status) — varchar(20)
- Field (merged_model_url) — varchar(255)
- Field (fail_reason) — varchar(1000)
- Field (ordered_at) — DATETIME
Untitled (users)
- Key (id) — bigint — Primary key — NOT NULL
- Field (email) — varchar(255)
- Field (password_hash) — varchar(255)
- Field (name) — varchar(50)
- Field (nickname) — varchar(50)
- Field (provider) — varchar(20)
- Field (provider_id) — varchar(255)
- Field (created_at) — DATETIME
Untitled (design_sessions)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (status) — varchar(20)
- Field (extracted_preferenced) — JSON
- Field (finger_overrides) — JSON
- Field (finger_dislikes) — JSON
- Field (generated_prompt) — TEXT
- Field (refine_keywords) — JSON
- Field (reference_image_url) — varchar(255)
- Field (created_at) — DATETIME
Untitled (chat_messages)
- Key (id) — bigint — Primary key — NOT NULL
- Key (session_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (role) — varchar(10)
- Field (content) — TEXT
- Field (sent_at) — DATETIME
Untitled (saved_folders)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(50)
- Field (sort_order) — int
- Field (is_default) — tinyint(1)
- Field (created_at) — DATETIME
Untitled (nail_designs)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (session_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (prompt_summary) — TEXT
- Field (ai_model) — varchar(500)
- Field (status) — varchar(20)
- Field (design_plan) — JSON
- Field (color_palette) — JSON
- Field (nail_tip_crops) — JSON
- Field (swatched_json) — JSON
- Field (seed) — bigint
- Field (reference_image_url) — varchar(255)
- Field (is_shared) — tinyint(1)
- Field (shared_at) — DATETIME
- Field (generated_at) — DATETIME
- Key (user_id2) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (nail_design_images)
- Key (nail_design_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — varchar(500)
Untitled (design_likes)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_id2) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (nail_design_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (liked_at) — DATETIME
Untitled (saved_designs)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (nail_design_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_id2) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (saved_folder_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — varchar(500)
- Field (saved_at) — DATETIME
- Key (user_id3) — bigint — Foreign key → Untitled.Key — NOT NULL
scan_images
- Key (id) — bigint — Primary key — NOT NULL
- Key (scan_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (finger) — varchar(10)
- Field2 (image_url) — varchar(500)
- Field (image_url_side) — varchar(500)
- Field (stl_url) — varchar(500)
- Field (measurements) — JSON
- Field (size) — varchar(20)
- Field (created_at) — DATETIME