과제

테이블 (4)

chat (Untitled3)

  • id (Key) — INT — 기본 키 — NOT NULL
  • createdAt (Field) — DATE
  • isDelete (Field2) — BOOLEAN
  • deletedAt (Field3) — DATE

chatHistory (Untitled2)

  • id (Key) — INT — 기본 키 — NOT NULL
  • content (Field) — TEXT
  • createdAt (Field2) — DATE
  • isDelete (Field3) — BOOLEAN
  • deletedAt (Field4) — DATE
  • connectId (Key2) — INT — 외래 키 → connect.id — NOT NULL
  • chatId (Key22) — INT — 외래 키 → connect.chatId — NOT NULL

connect (Untitled4)

  • id (Key) — INT — 기본 키 — NOT NULL
  • chatId (Key2) — INT — 외래 키 → chat.id — NOT NULL
  • userId (Key3) — INT — 외래 키 → user.id — NOT NULL
  • createdAt (Field) — DATE

user (Untitled)

  • id (Key) — INT — 기본 키 — NOT NULL
  • userId (Field10) — VARCHAR(150)
  • password (Field9) — VARCHAR(200)
  • username (Field) — VARCHAR(100)
  • nickname (Field2) — VARCHAR(100)
  • email (Field4) — VARCHAR(150)
  • mobile (Field5) — VARCHAR(15)
  • birth (Field3) — DATE
  • createdAt (Field6) — DATE
  • isExit (Field7) — BOOLEAN
  • exitedAt (Field8) — DATE