JPA 연습용 ERD
테이블 (6)
Auth (auth)
- pid — NOT NULL — 기본 키 — NOT NULL
- member_pid — NOT NULL — 외래 키 → Member.pid — NOT NULL
- loginId — NOT NULL
- password — NOT NULL
- createDate — NOT NULL
- lastModifiedDate — NOT NULL
Member (member)
- pid — NOT NULL — 기본 키 — NOT NULL
- useranme (username) — NOT NULL
- age
- email — NOT NULL
- phone — NOT NULL
- createDate — NOT NULL
- lastModifiedDate — NOT NULL
- usernick — NOT NULL
- address — NOT NULL
Post (post)
- pid — NOT NULL — 기본 키 — NOT NULL
- auth_pid — NOT NULL — 외래 키 → Auth.pid — NOT NULL
- content — NOT NULL
- title — NOT NULL
- createDate — NOT NULL
- lastModifiedDate — NOT NULL
ROLE (role)
- role_pid — NOT NULL — 기본 키 — NOT NULL
- rolename — NOT NULL
RefreshToken (refreshToken)
- pid — NOT NULL — 기본 키 — NOT NULL
- auth_id — NOT NULL — 외래 키 → Auth.pid — NOT NULL
- refreshToken — NOT NULL
- createDate — NOT NULL
- lastModifiedDate — NOT NULL
RoleAndAuth (roleAndAuth)
- pid — NOT NULL — 기본 키 — NOT NULL
- auth_pid — NOT NULL — 외래 키 → Auth.pid — NOT NULL
- role_pid — NOT NULL — 외래 키 → ROLE.role_pid — NOT NULL