java_pj
Tables (3)
rooms
- Key (room_id) — BIGINT — Primary key — NOT NULL
- room_code — VARCHAR(50) — NOT NULL — 방 코드 (고유 식별자)
- created_at — TIMESTAMP — 방 생성일시
saved_drawings
- Key (img_id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → users.Key — NOT NULL
- Key (room_id) — BIGINT — Foreign key → rooms.Key — NOT NULL
- s3_url — VARCHAR(500) — NOT NULL — S3에 저장된 이미지 URL
- created_at — TIMESTAMP — 저장일시
- Field (room_code) — VARCHAR(50)
users
- Key (user_id) — BIGINT — Primary key — NOT NULL
- username (email) — VARCHAR(50) — NOT NULL — 로그인 아이디
- password — VARCHAR(255) — NOT NULL — 비밀번호 (암호화 저장 권장)
- nickname — VARCHAR(50) — NOT NULL — 닉네임