Java
Tables (3)
tb_comment (댓글)
- idx (인덱스) — pk,ai — Primary key — NOT NULL
- post_idx (게시글idx) — fk,ai — Foreign key → tb_post.idx — NOT NULL
- content (내용) — nn
- author (글쓴이) — nn
- Field
- idx (인덱스2) — pk,ai — Foreign key → tb_user.idx — NOT NULL
tb_post (게시글)
- idx (인덱스) — pk,ai — Primary key — NOT NULL
- title (제목) — nn
- content (내용) — nn
- author (글쓴이) — fk,nn
- likes (좋아요)
- createdDateTime (생성날짜) — nn
- modifiedDateTime (수정날짜) — nn
- idx (인덱스2) — pk,ai — Foreign key → tb_user.idx — NOT NULL
tb_user (유저)
- idx (인덱스) — pk,ai — Primary key — NOT NULL
- userId (유저 아이디) — nn
- email (이메일) — nn
- password (비밀번호) — nn
- user_role (유저 권한) — nn
- createdDateTime (생성날짜) — nn
- modifiedDateTime (수정날짜) — nn