claWard
Tables (3)
member (사용자 정보 저장)
- id (Key) — BIGINT — Primary key — NOT NULL
- username (Field) — VARCHAR(50)
- password (Field2)
- email (Field3) — VARCHAR(100)
- created_at (Field4) — DATETIME
post (게시글 정보 저장)
- id (Key) — BIGINT — Primary key — NOT NULL
- member_id (Key2) — BIGINT — Foreign key → member.id — NOT NULL
- title (Field) — VACHAR(200)
- content (Field2) — TEXT
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME
upload_file (게시글에 첨부된 파일 정보)
- id (Key) — BIGINT — Primary key — NOT NULL
- member_id (Key2) — BIGINT — Foreign key → post.id — NOT NULL
- post_id (Key22) — BIGINT — Foreign key → post.member_id — NOT NULL
- filename (Field) — VARCHAR(255)
- filepath (Field2) — VARCHAR(255)
- uploaded_at (Field3) — DATETIME