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?