pre.study.spring7

Tables (3)

Untitled (comments)

  • Key (id) — bigserial — Primary key — NOT NULL
  • Field (post_id) — bigint — NOT NULL — posts .id
  • Field (user_id) — bigint
  • Field (username)
  • Field (content)
  • Field (inserted_at)
  • Field (updated_at)
  • Field (is_deleted) — char(1)
  • Field (deleted_at) — timestamp

posts

  • id — bigserial — Primary key — NOT NULL
  • title — varchar(100) — NOT NULL
  • user_id — bigint — users.id
  • author_name — varchar(20) — NOT NULL — user_id = 0 이면 해당 값도 익명
  • content — text
  • lock_yn — char(1) — NOT NULL
  • post_pwd — varchar(16)
  • inserted_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • Field (is_deleted) — char(1) — NOT NULL
  • Field (deleted_at) — timestamp — 삭제처리되었을때 update

users

  • id — bigserial — Primary key — NOT NULL
  • user_id — varchar(16) — NOT NULL
  • user_pwd — varchar(100) — NOT NULL
  • user_name — varchar(100) — NOT NULL
  • role — varchar(10) — NOT NULL
  • inserted_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • last_login_at — timestamp — NOT NULL — 해당 컬럼 저장 여부 결정해야 함
  • Field (is_deleted) — char(1) — NOT NULL
  • Field (deleted_at) — timestamp — 삭제 처리 되었을 때 update