curiator

Tables (7)

audio_file (Untitled5)

  • audio_id (Key) — bigint — Primary key — NOT NULL
  • narration_id (Key2) — bigint — Foreign key → narration.narration_id — NOT NULL
  • file_url (Field) — archer(100)
  • file_format (Field2) — varchar(10)
  • file_size (Field3) — bigint

item_content (Untitled2)

  • item_content_id (Key) — bigint — Primary key — NOT NULL
  • museum_item_id (Key2) — bigint — Foreign key → museum_item.museum_item_id — NOT NULL
  • description (Field) — archer(1000)
  • Field2

listner_history (Untitled7)

  • history_id (Key) — igint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.user_id — NOT NULL
  • play_duration (Field) — bigint

museum_item (Untitled)

  • museum_item_id (Key) — bigint — Primary key — NOT NULL
  • relic_id (Field) — String
  • title (Field2) — varchar(100)
  • qr_code (Field3) — varchar
  • artist (Field4) — varchar(100)

narration (Untitled3)

  • narration_id (Key) — bigint — Primary key — NOT NULL
  • persona_id (Key2) — bigint — Foreign key → persona.persona_id — NOT NULL
  • script_text (Field) — varchar(1000)

persona (Untitled4)

  • persona_id (Key) — bigint — Primary key — NOT NULL
  • persona_name (Field) — varchar(100)
  • voice_type (Field2) — enum
  • Field3

user (Untitled6)

  • user_id (Key) — bigint — Primary key — NOT NULL
  • username (Field) — archer(100)