test
Tables (4)
Board
- Board_id — VARCHAR(50)
- //게시물 — 아이디 — NOT NULL
- //작성자 — 아이디 — NOT NULL
- //카테고리 — 아이디
- 카테고리 — 테이블과 — NOT NULL
- content — TEXT — NOT NULL
- creation_date — TIMESTAMP
- modification_date — TIMESTAMP
- likes — INT
- comments — INT
Category
- category_id — INT
- category_name — VARCHAR(100) — NOT NULL
- category_description — TEXT
Comment
- comment_id — VARCHAR(50)
- Board_id — VARCHAR(50) — NOT NULL
- //게사물 — 아이디 — NOT NULL
- content — TEXT — NOT NULL
- creation_date — TIMESTAMP
- modification_date — TIMESTAMP
Member
- mem_id — VARCHAR(50)
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- registration_date — TIMESTAMP
- profile_picture — VARCHAR(255)
- Tel — VARCHAR(20) — NOT NULL