hw1
Tables (7)
Comment (댓글)
- Comment_id (댓글번호) — Primary key — NOT NULL
- content (내용)
- created_at (생성날짜)
- post_id (게시글번호2) — Foreign key → Post.post_id — NOT NULL
- user_id (유저번호) — Foreign key → User.user_id — NOT NULL
Like (좋아요)
- like_id (좋아요번호) — Primary key — NOT NULL
- post_id (게시글번호) — Foreign key → Post.post_id — NOT NULL
- user_id (유저번호) — Foreign key → User.user_id — NOT NULL
Post (게시글)
- post_id (게시글번호) — Primary key — NOT NULL
- title (제목)
- content (본문)
- created_at (생성날짜)
- user_id (유저번호) — Foreign key → User.user_id — NOT NULL
- posttag_id (posttag번호) — Foreign key → Post_Tag.posttag_id — NOT NULL
Post_Tag (게시글-태그)
- posttag_id (posttag번호) — Primary key — NOT NULL
- tag_id (태그번호) — Foreign key → Tag.tag_id — NOT NULL
Profile (프로필)
- id (프로필번호) — Primary key — NOT NULL
- Collegee (대학)
- Major (전공)
- user_id (유저번호) — Foreign key → User.user_id — NOT NULL
Tag (태그)
- tag_id (태그번호) — Primary key — NOT NULL
- content (내용)
User (유저)
- user_id (유저번호) — Primary key — NOT NULL
- user_name (이름)
- password (비밀번호)
- Field3 (이메일)