모델링 공부

테이블 (6)

comments (Untitled3)

  • id (Key) — INT — 기본 키 — NOT NULL
  • comment (Field) — VARCHAR(100)
  • grade (Field2) — INT(1)
  • createAt (Field3) — DATE
  • updateAt (Field4) — DATE
  • isDelete (Field5) — TINYINT(1)
  • UserKey (Key2) — INT — 외래 키 → users.id — NOT NULL
  • ContentKey (Key3) — INT — 외래 키 → contents.id — NOT NULL

contentTypes (Untitled5)

  • id (Key) — INT — 기본 키 — NOT NULL
  • typeName (Field) — VARCHAR(50)
  • createAt (Field2) — DATE
  • updateAt (Field3) — DATE
  • isDelete (Field4) — TINYINT(1)

contents (Untitled2)

  • id (Key) — INT — 기본 키 — NOT NULL
  • title (Field) — VARCHAR(50)
  • content (Field2) — VARCHAR(500)
  • isDelete (Field3) — TINYINT(1)
  • createAt (Field4) — DATE
  • updateAt (Field5) — DATE
  • views (Field6) — INT(100)
  • suggestions (Field7) — INT(100)
  • UserKey (Key2) — INT — 외래 키 → users.id — NOT NULL
  • TypeKey (Key3) — INT — 외래 키 → contentTypes.id — NOT NULL

files (Untitled4)

  • id (Key) — INT — 기본 키 — NOT NULL
  • originName (Field) — VARCHAR(100)
  • ext (Field2) — VARCHAR(10)
  • filePath (Field3) — VARCHAR(200)
  • createAt (Field4) — DATE
  • ContentKey (Key2) — INT — 외래 키 → contents.id — NOT NULL

suggestion (Untitled6)

  • id (Key) — INT — 기본 키 — NOT NULL
  • userSuggestion (Field) — TINYINT(1)
  • UserKey (Key2) — INT — 외래 키 → users.id — NOT NULL
  • ContentKEY (Key3) — INT — 외래 키 → contents.id — NOT NULL

users (Untitled)

  • id (Key) — INT — 기본 키 — NOT NULL
  • userName (Field) — VARCHAR(20)
  • userId (Field2) — VARCHAR(20)
  • userPassword (Field3) — VARCHAR(20)
  • createAt (Field4) — DATE
  • userEmail (Field5) — VARCHAR(50)
  • isDelete (Field6) — TINYINT(1)
  • userBirth (Field7) — DATE