yesvel

Tables (6)

Chapter (CHAPTER)

  • id — BIGINT — Primary key — NOT NULL
  • workId (work_id) — BIGINT — Foreign key → Work.id — NOT NULL
  • content (content_url) — VARCHAR — NOT NULL
  • volume — FLOAT — NOT NULL
  • pageSize (page_size) — SMALLINT — NOT NULL
  • isFree (free_yn) — BIT(1) — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL

Member (MEMBER)

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR — NOT NULL
  • password — VARCHAR — NOT NULL
  • nickname — VARCHAR — NOT NULL
  • cash — MEDIUMINT — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL

OwnedChapter (OWNED_CHAPTER)

  • id — BIGINT — Primary key — NOT NULL
  • ownerId (owner_id) — BIGINT — Foreign key → Member.id — NOT NULL
  • chapterId (chapter_id) — BIGINT — Foreign key → Chapter.id — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL

Payment (PAYMENT)

  • id — BIGINT — Primary key — NOT NULL

ReaderWork (READER_WORK)

  • id — BIGINT — Primary key — NOT NULL
  • readerId (reader_id) — BIGINT — Foreign key → Member.id — NOT NULL
  • workId (word_id) — BIGINT — Foreign key → Work.id — NOT NULL
  • lastReadChapter (last_read_chapter_number) — SMALLINT
  • isFavorite (favorite_yn) — BIT(1) — NOT NULL
  • ticketCount (ticket_count) — SMALLINT — NOT NULL
  • ownedChapterCount (owned_chapter_count) — SMALLINT — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL

Work (WORK)

  • id — BIGINT — Primary key — NOT NULL
  • authorId (author_id) — BIGINT — Foreign key → Member.id — NOT NULL
  • genre — VARCHAR — NOT NULL
  • title — VARCHAR — NOT NULL
  • coverImage (cover_image_url) — VARCHAR — NOT NULL
  • decription — VARCHAR — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL