ERD
Tables (8)
auth_user
- id — BIGINT
- username — VARCHAR(150) — NOT NULL
- email — VARCHAR(254)
generated_stories
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → auth_user.id — NOT NULL
- region — VARCHAR(100)
- place — TEXT
- entity_type — VARCHAR(100)
- taboo_text — TEXT
- event_time — VARCHAR(100)
- condition — TEXT
- ending — TEXT
- title — TEXT
- content — TEXT
- status — VARCHAR(30)
- visibility — VARCHAR(30)
- prompt_payload — JSONB
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
generated_story_bookmarks
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → auth_user.id — NOT NULL
- generated_story_id — BIGINT — Foreign key → generated_stories.id — NOT NULL
- memo — TEXT
- created_at — TIMESTAMPTZ
horror_stories
- id — BIGSERIAL
- source — VARCHAR(100) — NOT NULL
- source_ref_id — VARCHAR(100) — NOT NULL
- title — TEXT — NOT NULL
- language — VARCHAR(20)
- region — VARCHAR(100)
- url — TEXT
- preview — TEXT
- content — TEXT — NOT NULL
- category — VARCHAR(100)
- metadata — JSONB
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
myth_entities
- id — BIGSERIAL
- source — VARCHAR(100) — NOT NULL
- source_ref_id — VARCHAR(100) — NOT NULL
- name — TEXT — NOT NULL
- origin — VARCHAR(255)
- description — TEXT
- behavior — TEXT
- weakness — TEXT
- history — TEXT
- signs — TEXT
- survival_rules — JSONB
- source_site — VARCHAR(100)
- source_url — TEXT
- metadata — JSONB
post_bookmarks
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → auth_user.id — NOT NULL
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- memo — TEXT
- created_at — TIMESTAMPTZ
posts
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → auth_user.id — NOT NULL
- board_type — VARCHAR(30)
- title — TEXT — NOT NULL
- region — VARCHAR(100)
- content — TEXT — NOT NULL
- view_count — INTEGER
- visibility — VARCHAR(30)
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
superstitions
- id — BIGSERIAL
- source — VARCHAR(100) — NOT NULL
- source_ref_id — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- category — VARCHAR(100)
- region — VARCHAR(100)
- metadata — JSONB