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