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 — 닉네임