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