solpim
TUD individual project
Tables (20)
Artists (artist)
- PK (id) — UUID — Primary key — NOT NULL
- User FK (user_id) — Foreign key → Users.PK — NOT NULL
- University FK (university_id) — Foreign key → Universisties.PK — NOT NULL
- Department FK (department_id) — Foreign key → Departments.PK — NOT NULL
- Introduction (bio) — TEXT
- Information (SNS, website) (portfolio_url) — TEXT
- Graduate year (graduation_year) — INTEGER
- background image (background_img) — TEXT
Artwork Contents (artworkContent)
- PK (id) — UUID — Primary key — NOT NULL
- Artwork FK (artwork_id) — Foreign key → Artworks.PK — NOT NULL
- Type (type) — ENUM
- Section (section) — VARCHAR(50)
- content — TEXT
- Order Index (order_index) — INTEGER
Artwork Review (artwork_review)
- PK (id) — UUID — Primary key — NOT NULL
- Artwork FK (artwork_id) — Foreign key → Artworks.PK — NOT NULL
- User FK (user_id) — Foreign key → Users.PK — NOT NULL
- status — ENUM
- Reason (rejection_reason) — TEXT
- Review at (review_at) — TIMESTAMP
ArtworkTags (artworkTag)
- PK (artwork_id, tag_id) — Primary key — NOT NULL
- Artwork PK (artwork_id) — Foreign key → Artworks.PK — NOT NULL
- Tag Pk (tag_id) — Foreign key → Tags.PK — NOT NULL
Artworks (artwork)
- PK (id) — UUID — Primary key — NOT NULL
- Artist FK (artist_id) — Foreign key → Artists.PK — NOT NULL
- Category FK (category_id) — Foreign key → Categories.PK — NOT NULL
- Artwork title (title) — VARCHAR(255)
- description — TEXT
- Thumbnail (thumbnail_url) — TEXT
- Production start date (production_start) — DATE
- Production end date (production_end) — DATE
- For sale (for_sale) — BOOLEAN
- View count (view_count) — INTEGER
- status — ENUM
- Created at (created_at) — TIMESTAMP
Artworks (artworks)
- PK (id) — string — Primary key — NOT NULL
- Artwork title (title) — string
- description — string?
- Category (category)
- Thumbnail (thumbnailUrl) — string
- thumbnail id (thumbnailContentId) — string?
- video (related video)
- Owner FK (ownerUid) — string — Foreign key → Users.PK — NOT NULL
- status — ENUM
- Reject reason (rejectionReason) — string?
- Production start date (productionStart) — string?
- Production end date (productionEnd) — string?
- For sale (availableForSale) — boolean?
- terms agree (termsAgreed) — boolean?
- Created at (created_at) — timestamp
- updated at (updateAt) — timestamp?
Categories (category)
- PK (id) — UUID — Primary key — NOT NULL
- Name (name) — VARCHAR(100)
Departments (department)
- PK (id) — UUID — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- University FK (university_id) — Foreign key → Universisties.PK — NOT NULL
Likes (like)
- PK (id) — UUID — Primary key — NOT NULL
- User FK (user_id) — Foreign key → Users.PK — NOT NULL
- Artwork FK (arwork_id) — Foreign key → Artworks.PK — NOT NULL
- create at (created_at) — TIMESTAMP
- UNIQUE (user_id, artwork_id)
Likes (likes)
- Key (likeId) — string — Primary key — NOT NULL
- user id (userId) — string — Foreign key → Users.PK — NOT NULL
- artwork id (artworkId) — string — Foreign key → Artworks.PK — NOT NULL
- create at (createAt) — timestamp
Notification (notification)
- PK (id) — UUID — Primary key — NOT NULL
- Sender FK (sender_id) — Foreign key → Users.PK — NOT NULL
- Receiver FK (receiver_id) — Foreign key → Users.PK — NOT NULL
- Type (type) — ENUM
- Message (msg) — TEXT
- Artwork FK (artwork_id) — NULL — Foreign key → Artworks.PK — NOT NULL
- Created at (created_at) — TIMESTAMP
- Is read (is_read) — BOOLEAN
Notifications (notifications)
- Key (notificationId) — string — Primary key — NOT NULL
- receiver (receiverId) — string — Foreign key → Users.PK — NOT NULL
- sender (senderId) — string — Foreign key → Users.PK — NOT NULL
- sender name (senderName) — string?
- artwork id (artworkId) — string — Foreign key → Artworks.PK — NOT NULL
- artworkTitle — striing?
- msg type (type) — ENUM
- msg (message) — string
- isRead — boolean
- create at (createAt) — timestamp
Tags (tag)
- PK (id) — UUID — Primary key — NOT NULL
- Name (name) — VARCHAR(50)
Universisties (university)
- PK (id) — UUID — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
Users (user)
- PK (id) — UUID — Primary key — NOT NULL
- name (Name) — VARCHAR(100)
- Email (email) — VARCHAR(255)
- Role (role) — Enum
- Profile Image (img_url) — TEXT
- Created at (created at) — TIMESTAMP
Users (users)
- PK (id) — string — Primary key — NOT NULL
- Email (email) — string
- Name (name) — string
- Profile Image (profileimageUrl) — string
- Role (role) — Enum
- Background Image (backgroundImageUrl) — string?
- University (university) — string?
- Department (department) — string?
- Major (major) — string?
- Country (country) — string?
- Graduation date (expectedGraduationDate) — string?
- University verification (universityVerificationStatus)
- Create date (createAt) — timestamp
- Update date (updateAt) — timestamp
artworks.images[] (Untitled)
- PK (contentId) — string — Foreign key → Artworks.PK — NOT NULL
- Img name (imageName) — string
- content type (contentType) — string
- content len (contentLength) — number?
- s3 object key (s3ObjectKey) — string
- bucket name (bucketName) — string
- region — string
protectedArtworks (protected arworks)
- PK (artworkId) — string — Foreign key → Artworks.PK — NOT NULL
- title — string
- Img name (imageName) — string
- content id (contentId) — string?
- owner FK (ownerUid) — string — Foreign key → Users.PK — NOT NULL
- create at (createAt) — timestamp
- update at (updateAt) — timestamp?
protection
- embedded (protectionStatus) — string
- status
- Image hash (imageHash) — string?
- ipfs cid (ipfsCid) — string?
- blockchain hash (blockchainTxHash) — string?
- chain name (chainName) — string?
- requested at (requestedAt) — timestaml?
- uploaded at (uploadedAt) — timestamp?
- approved at (approvedAt) — timestamp?
- hashed at (hashedAt) — timestamp?
- pinned at (pinnedAt) — timestamp?
- registered at (registeredAt) — timestamp?
- failed at (failedAt) — timestamp?
- approver id FK (approvedBy) — string — Foreign key → Users.PK — NOT NULL
- errorCode — string?
- error msg (errorMessage) — string?
storage (Untitled2)
- embedded (objectKey) — string
- provider — s3
- bucket name (bucketName) — string
- region — string
- content type (contentType) — string?
- content len (contentLength) — number?
- eTag — string?