모델링 연습

테이블 (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)