hEARit

Tables (6)

Bookmark

  • id (hearit_id) — LONG — Foreign key → Hearit.id
  • id (member_id) — LONG — Foreign key → Member.id

Category

  • id — LONG — Primary key
  • name — VARCHAR(100) — NOT NULL

Hearit

  • id — LONG — Primary key
  • category_id — LONG — Foreign key → Category.id
  • id (member_id) — LONG — Foreign key → Member.id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • audio_url — VARCHAR(500)
  • script_url (transcript_url) — VARCHAR(500)
  • created_at — DATETIME
  • updated_at — DATETIME

ListeningHistory

  • id — BIGINT
  • listened_at — int
  • id (member_id) — LONG — Foreign key → Member.id
  • id (hearit_id) — LONG — Foreign key → Hearit.id

Member

  • id — LONG — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • nickname — VARCHAR(50)

OAuthProvider

  • id — BIGINT
  • user_id — BIGINT
  • provider_name — ENUM('GOOGLE', 'NAVER', 'KAKAO')
  • provider_user_id — VARCHAR(255)