일침

테이블 (4)

attendance

  • attendance_id — INT — 기본 키 — NOT NULL
  • crew_id — INT — 외래 키 → crew.crew_id — NOT NULL
  • attendance_date — DATE — NOT NULL
  • start_time — TIME
  • end_time — TIME

crew

  • crew_id — INT — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL

game

  • id — BIGINT
  • turn — VARCHAR(10) — NOT NULL
  • is_active — BOOLEAN — NOT NULL

piece

  • id — BIGINT
  • game_id — BIGINT — 외래 키 → game.id — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • side — VARCHAR(10) — NOT NULL
  • row_idx — BIGINT — NOT NULL
  • col_idx — BIGINT — NOT NULL