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