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