ssafit
Tables (5)
Follow
- relation_id — Primary key — NOT NULL
- follower_id — BIGINT — Foreign key → Member.회원ID — NOT NULL
- followee_id — BIGINT — Foreign key → Member.회원ID — NOT NULL
Like
- like_id — Primary key — NOT NULL
- video_id — BIGINT — Foreign key → Video.video_id — NOT NULL
- member_id — BIGINT — Foreign key → Member.회원ID — NOT NULL
- liked_at — TIMESTAMP
Member
- 회원ID (member_id) — BIGINT — Primary key — NOT NULL
- ID — VARCHAR(30) — NOT NULL
- password — CHAR(64) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- email — VARCHAR(30) — NOT NULL
- signup_date — TIMESTAMP — NOT NULL
- status — VARCHAR(10) — NOT NULL
- deleted_at — TIMESTAMP
Review
- review_id — BIGINT — Primary key — NOT NULL
- content — VARCHAR(500)
- created_at — TIMESTAMP
- video_id — BIGINT — Foreign key → Video.video_id — NOT NULL
- member_id — BIGINT — Foreign key → Member.회원ID — NOT NULL
Video
- video_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(50)
- content — VARCHAR(500)
- created_at — TIMESTAMP
- video_address — VARCHAR(200) — NOT NULL
- like — INT
- member_id — BIGINT — Foreign key → Member.회원ID — NOT NULL
- category — VARCHAR(50)