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