likelion_blog
Tables (4)
Comment (댓글)
- comment_id (댓글 번호) — Primary key — NOT NULL
- content (내용)
- created_at (작성일자)
- user_id (유저 번호) — Foreign key → User.user_id — NOT NULL
- post_id (게시글 번호) — Foreign key → Post.post_id — NOT NULL
Post (게시글)
- post_id (게시글 번호) — Primary key — NOT NULL
- title (제목)
- content (내용)
- created_at (게시일자)
- user_id (유저 번호) — Foreign key → User.user_id — NOT NULL
User (사용자)
- user_id (유저 번호) — Primary key — NOT NULL
- username (이름)
- password (비밀번호)
- email (이메일)
- signed_up_at (회원가입 일자)
UserProfile (유저 정보)
- userprofile_id (유저정보 번호) — Primary key — NOT NULL
- major (Field)
- age (Field2)
- user_id (유저 번호) — Foreign key → User.user_id — NOT NULL