umc
Tables (7)
Cert (비번재발급)
- Key — Primary key — NOT NULL
- 임시 비밀번호 (Field)
- 이메일 (Field2)
- user_id (Field3)
JoinTerms (회원가입약관)
- terms_id (Key) — Primary key — NOT NULL
- user_id (유저ID) — Foreign key → User.user_id — NOT NULL
- 약관1 (Field)
- 약관2 (Field2)
- 약관3 (Field3)
- Field4
Post (글)
- post_id (글ID) — Primary key — NOT NULL
- user_id (유저ID) — Foreign key → User.user_id — NOT NULL
- Field
- Field2
Report (신고하기)
- Key — Primary key — NOT NULL
- user_id (유저ID) — Foreign key → User.user_id — NOT NULL
- user_id (유저ID2) — Foreign key → User.user_id — NOT NULL
- Field
- Field2
User (유저)
- user_id (유저ID) — Primary key — NOT NULL
- email (Field)
- univ (Field2)
- introduction (자기소개)
- picture (프사)
- accountId (아이디)
- password (비밀번호)
- Field5
- Field6
- Field7
- List<Post> (List<글>)
comment (댓글)
- comment_id (댓글_id) — Primary key — NOT NULL
- user_id (유저ID) — Foreign key → User.user_id — NOT NULL
- post_id (글ID) — Foreign key → Post.post_id — NOT NULL