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