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)