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