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