VisionArt

Tables (4)

Artwork

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • artist — VARCHAR(255) — NOT NULL
  • year — INT
  • description — TEXT
  • img_url — VARCHAR(2083)

GeneratedDescription

  • id — INT — Primary key — NOT NULL
  • id (photo_id) — INT — Foreign key → UserPhoto.id — NOT NULL
  • id (user_id) — UUID — Foreign key → User.id — NOT NULL
  • artwork_id — INT
  • generated_text — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

User

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(255)
  • password — BINARY(60)
  • difficulty_lv — ENUM('E', 'H')
  • description_st — VARCHAR(255)
  • clr_knowledge — tinyint
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

UserPhoto

  • id — INT — Primary key — NOT NULL
  • user_id — UUID — Foreign key → User.id — NOT NULL
  • photo_url — VARCHAR(2083)
  • uploaded_at — TIMESTAMP