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