toyproject1

Tables (4)

Chat (채팅)

  • Key — Primary key — NOT NULL
  • message (메시지) — TEXT
  • id (회원키) — INT — Foreign key → User.id — NOT NULL
  • id (채팅방키) — INT — Foreign key → ChattingRoom.id — NOT NULL

ChattingRoom (채팅방)

  • id (주요키) — INT — Primary key — NOT NULL
  • title (제목) — VARCHAR(30)
  • owner (방장 닉네임) — VARCHAR(20)

User (회원)

  • id (주요키) — INT — Primary key — NOT NULL
  • name (아이디) — VARCHAR(20)
  • password (비밀번호) — VARCHAR(50)
  • nickname (닉네임) — VARCHAR(20)

UserChattingRoom (회원채팅방)

  • id (주요키) — INT — Primary key — NOT NULL
  • id (회원키) — INT — Foreign key → User.id — NOT NULL
  • id (채팅방키) — INT — Foreign key → ChattingRoom.id — NOT NULL