게시판

테이블 (3)

account

  • idx — SERIAL
  • id — VARCHAR(20) — NOT NULL
  • pw — VARCHAR(20) — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • phonenumber — VARCHAR(15) — NOT NULL
  • email — VARCHAR(24) — NOT NULL
  • is_admin — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL

comment

  • idx — SERIAL
  • post_idx — INT — NOT NULL
  • account_idx — INT — NOT NULL
  • content — VARCHAR(600) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • modified_at — TIMESTAMP

post

  • idx — SERIAL
  • account_idx — INT — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • content — VARCHAR(3000) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • modified_at — TIMESTAMP