Oven
Tables (9)
Work_Provider (work_provider)
- workProviderId (work_provider_id) — Long — Primary key — NOT NULL
- workId (work_id) — Long — Foreign key → Work.workId — NOT NULL
- providerId (provider_id2) — Long — Foreign key → Provider.providerId — NOT NULL
Chatroom (chatroom)
- chatroomId (chatroom_id) — Long — Primary key — NOT NULL
- providerId (provider_id) — Long — Foreign key → Provider.providerId — NOT NULL
- chatroomUuid (chatroom_uuid) — UUID
Entrance (entrance)
- entranceId (entrance_id) — Long — Primary key — NOT NULL
- userId (user_id) — Long — Foreign key → User.userId — NOT NULL
- chatroomId (chatroom_id) — Long — Foreign key → Chatroom.chatroomId — NOT NULL
InterestingWork (interesting_work)
- interestingWork (interesting_work_id) — Long — Primary key — NOT NULL
- userId (user_id) — Long — Foreign key → User.userId — NOT NULL
- workId (work_id2) — Long — Foreign key → Work.workId — NOT NULL
Message (message)
- messageId (message_id) — Long — Primary key — NOT NULL
- chatroomId (chatroom_id) — Long — Foreign key → Chatroom.chatroomId — NOT NULL
- userId (user_id) — Long — Foreign key → User.userId — NOT NULL
- content — TEXT — NOT NULL
Provider (provider)
- providerId (provider_id) — Long — Primary key — NOT NULL
- name — String — NOT NULL
RatingWork (rating_work)
- ratingWorkId (rating_work_id) — Long — Primary key — NOT NULL
- userId (user_id) — Long — Foreign key → User.userId — NOT NULL
- workId (work_id2) — Long — Foreign key → Work.workId — NOT NULL
- rating — int — NOT NULL
User (user)
- userId (user_id) — Long — Primary key — NOT NULL
- userName (user_name) — String — NOT NULL
- password — String — NOT NULL
- createdAt (created_at) — TIMESTAMP — NOT NULL
- modifiedAt (modified_at) — TIMESTAMP — NOT NULL
Work (work)
- workId (work_id) — Long — Primary key — NOT NULL
- title — String — NOT NULL
- genre