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()