모델링 공부
테이블 (5)
Untitled (users)
- Key (id) — INT — 기본 키 — NOT NULL
- Field (userId) — VARCHAR(50))
- Field (userPassword) — VARCHAR(50)
- Field (userName) — VARCHAR(20)
- Field (userEmail) — VARCHAR(50)
- Field (userMobile) — VARCHAR(50)
- Field (createdAt) — DATE
- Field2 (updatedAt) — DATE
- Field (isDelete) — TINYINT(1)
Untitled (boards)
- Key (id) — INT — 기본 키 — NOT NULL
- Field (title) — VARCHAR(200)
- Field (content) — TEXT
- Field (createdAt) — DATE
- Field (updatedAt) — DATE
- Field (isDelete) — TINIYINT(1)
- Field (recommed) — INT
- Field (views) — INT
- Key (UserKey) — INT — 외래 키 → Untitled.Key — NOT NULL
- Key (TypeKey) — INT — 외래 키 → Untitled.Key — NOT NULL
- Key (commentsKey) — INT — 외래 키 → Untitled.Key — NOT NULL
Untitled (boardTypes)
- Key (id) — INT — 기본 키 — NOT NULL
- Field (typeName) — VARCHAR(30)
- Field (isDelete) — TINYINT(1)
Untitled (files)
- Key (id) — INT — 기본 키 — NOT NULL
- Field (originName) — VARCHAR(200)
- Field (ext) — VARCHAR(10)
- Field (filePath) — VARCHAR(500)
- Key (bordKey) — INT — 외래 키 → Untitled.Key — NOT NULL
Untitled (comments)
- Key (id) — INT — 기본 키 — NOT NULL
- Field (content) — VARCHAR(200)
- Field (grade) — INT(1)
- Key (UserKey) — INT — 외래 키 → Untitled.Key — NOT NULL