ssafit
Tables (6)
refresh_token
- user_id — VARCHAR(50) — Primary key — NOT NULL
- user_id (user_id2) — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
- token — TEXT
- expiry — DATETIME
review
- review_no — INT — Primary key — NOT NULL
- review_title — VARCHAR(100)
- review_content — TEXT
- reg_date — DATETIME
- writer_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
- video_no — INT — Foreign key → video.video_no — NOT NULL
user
- user_id — VARCHAR(50) — Primary key — NOT NULL
- user_name — VARCHAR(50) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- email — VARCHAR(100)
- age — INT
- created_at — DATETIME
user_favorite
- favorite_id — INT — Primary key — NOT NULL
- video_no — INT — Foreign key → video.video_no — NOT NULL
- video_id — VARCHAR(255)
- created_at — DATETIME
- user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
user_recommend
- user_id — VARCHAR(50) — Primary key — NOT NULL
- video_id — VARCHAR(50) — Primary key — NOT NULL
- user_id (user_id2) — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
- created_at — DATETIME
video
- video_no — INT — Primary key — NOT NULL
- video_title — VARCHAR(255) — NOT NULL
- channel_name — VARCHAR(50) — NOT NULL
- view_count — INT
- upload_date — DATETIME
- video_like — INT
- field — VARCHAR(100)
- fitness_part_no — INT
- video_id — VARCHAR(100)
- thumbnail_url — VARCHAR(500)
- tag — VARCHAR(100)