모델링 연습
테이블 (7)
boardTypes (Untitled)
- id (Key) — INT — 기본 키 — NOT NULL
- typeName (Field) — VARCHAR(200)
boards
- id (Key) — INT — 기본 키 — NOT NULL
- title (Field) — VARCHAR(200)
- content (Field2) — VARCHAR(500)
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
- isDelete (Field7) — TINYINT(1)
- like (Field6) — INT
- hit (Field5) — INT
- userKey (Key2) — INT — 외래 키 → users.id — NOT NULL
- typeKey (Key3) — INT — 외래 키 → boardTypes.id — NOT NULL
comments (Untitled3)
- Key — INT — 기본 키 — NOT NULL
- title (Field) — VARCHAR(50)
- content (Field2) — VARCHAR(200)
- userKey (Key2) — INT — 외래 키 → users.id — NOT NULL
- boardKey (Key3) — INT — 외래 키 → boards.id — NOT NULL
- isDelete (Field3) — TINYINT(1)
files (Untitled2)
- Key — INT — 기본 키 — NOT NULL
- originName (Field) — VARCHAR(200)
- ext (Field2) — VARCHAR(20)
- filePath (Field3) — VARCHAR(500)
- boardKey (Key2) — INT — 외래 키 → boards.id — NOT NULL
gradenumbers (Untitled4)
- Key — INT — 기본 키 — NOT NULL
- gradeNumber (Field) — INT
- commentKey (Key2) — INT — 외래 키 → comments.Key — NOT NULL
likes (Untitled5)
- id (Key) — INT — 기본 키 — NOT NULL
- dislike (Field) — TINYINT(1)
- userKey (Key2) — INT — 외래 키 → users.id — NOT NULL
- boardKey (Key3) — INT — 외래 키 → boards.id — NOT NULL
users
- id (Key) — INT — 기본 키 — NOT NULL
- userId (Field) — VARCHAR(50)
- userPassword (Field2) — VARCHAR(20)
- userName (Field3) — VARCHAR(50)
- userEmail (Field4) — VARCHAR(50)
- userMobile (Field5) — VARCHAR(50)
- createdAt (Field6) — DATE
- updatedAt (Field7) — DATE
- isDelete (Field8) — TINYINT(1)