erd

Tables (3)

board_table (CopyOfUntitled)

  • post_num (PRI) — 고유식별값 — Primary key — NOT NULL
  • title (Field2) — not null — NOT NULL
  • content (Field3) — not null
  • created_at (Field5) — now()
  • likeCount (Field4)
  • user_num (Field6) — FK
  • image_path (Field7) — default null
  • updated_at (Field) — now()
  • deleted (Field8) — default N

comment_table (Untitled2)

  • post_num (Field) — not null, FK
  • content (Field2) — not null
  • user_num (Field3) — FK
  • created_at (Field4) — now()
  • updated_at (Field5) — now()
  • deleted (Field6) — default N

user_table (Untitled)

  • user_num (PRI) — 고유식별값, PK — Primary key
  • username(id) (Field2) — not null
  • password (Field3) — sha-256
  • salt (Field) — os.urandom(32)
  • nickname (Field4) — not null
  • email (Field5) — not null
  • signupdate (Field6) — now()