translation_chat
Tables (4)
chat_room (일반 채팅방)
- Key — BIGINT — Primary key — NOT NULL
- Field (대화상대이름) — VARCHAR(255)
- Field2 (마지막 메세지 내용) — VARCHAR(255)
- Field3 (마지막 메세지 날짜) — DATETIME
chat_room_has_user (채팅방에 참여한 회원)
- Key (pk) — BIGINT — Foreign key → user.Key — NOT NULL
- Key — BIGINT — Foreign key → chat_room.Key — NOT NULL
- Key (pk2) — BIGINT — Foreign key → user.Key — NOT NULL
friend (친구)
- Key (pk) — BIGINT — Foreign key → user.Key — NOT NULL
- Key (pk2) — BIGINT — Foreign key → user.Key — NOT NULL
- Field — BOOLEAN
user (회원)
- Key (pk) — BIGINT — Primary key — NOT NULL
- Key (pk2) — BIGINT — Foreign key → friend.Key — NOT NULL
- Field (계정) — VARCHAR(255)
- Field (패스워드) — VARCHAR(255)
- Field (아이디) — VARCHAR(255)
- Field (국적) — VARCHAR(255)
- Field (언어) — VARCHAR(255)
- Field (랜덤 채팅 사용 여부) — BOOLEAN
- Field (가입일) — DATETIME
- Field (누적 경고 횟수) — INT
- Field (랜덤 채팅 사용 가능 날짜) — DATETIME