sjseo_web_novel
Tables (11)
bookmark
- id — INT — Primary key
- user_id — INT — NOT NULL
- episode_id — INT — NOT NULL
- bookmarked_at — DATETIME — NOT NULL
cache
- cache_key — VARCHAR(255)
- cache_value — TEXT
comment
- id — INT — Primary key
- user_id — INT — Foreign key → user.id
- episode_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
episode
- id — INT — Primary key
- novel_id — INT — Foreign key → novel.id
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- purchase_count — INT
like
- id — INT
- user_id — INT — NOT NULL
- episode_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
novel
- id — INT — Primary key
- author_id — INT — Foreign key → user.id
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- created_at — DATETIME — NOT NULL
preference
- id — INT — Primary key
- user_id — INT — Foreign key → user.id
- novel_id — INT — Foreign key → novel.id
- last_episode_id — INT — NOT NULL
purchase
- id — INT — Primary key
- user_id — INT — NOT NULL
- episode_id — INT — NOT NULL
- purchased_at — DATETIME — NOT NULL
purchase_episode
- id — INT — Primary key
- purchase_id — INT — NOT NULL
- episode_id — INT — NOT NULL
report
- id — INT — Primary key
- user_id — INT — NOT NULL
- episode_id — INT — NOT NULL
- reason — VARCHAR(255) — NOT NULL
- reported_at — DATETIME — NOT NULL
user
- id — INT — Primary key
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- Field