DRF-Practice

[Django REST Framework 개발부터 배포까지] 프로젝트의 데이터베이스 ERD 입니다. Blog: https://devpro.kr GitHub: https://github.com/Jiseoup/DRF-Practice

테이블 (3)

Untitled (post)

  • Key (post_no) — serial — 기본 키 — NOT NULL
  • Key (author) — integer — 외래 키 → Untitled.Key — NOT NULL
  • Field (title) — varchar(100) — NOT NULL
  • Field (content) — text — NOT NULL
  • Field2 (created_at) — timestamp — NOT NULL
  • Field3 (updated_at) — timestamp — NOT NULL

Untitled (comment)

  • Key (comment_no) — bigserial — 기본 키 — NOT NULL
  • Key (post) — integer — 외래 키 → Untitled.Key — NOT NULL
  • Key (author) — integer — 외래 키 → Untitled.Key — NOT NULL
  • Field3 (content) — text — NOT NULL
  • Field4 (created_at) — timestamp — NOT NULL
  • Field5 (updated_at) — timestamp — NOT NULL

Untitled (auth_user)

  • Key (id) — serial — 기본 키 — NOT NULL
  • Field (password) — varchar(128) — NOT NULL
  • Field2 (last_login) — timestamp
  • Field3 (is_superuser) — boolean — NOT NULL
  • Field4 (username) — varchar(150) — NOT NULL
  • Field (first_name) — varchar(150) — NOT NULL
  • Field (last_name) — varchar(150) — NOT NULL
  • Field (email) — varchar(254) — NOT NULL
  • Field (is_staff) — boolean — NOT NULL
  • Field (is_active) — boolean — NOT NULL
  • Field (date_joined) — timestamp — NOT NULL