스크린

테이블 (3)

screen_invite

  • id — int — 기본 키 — NOT NULL
  • id (screen_id) — INT(10) — 외래 키 → screens.id — NOT NULL
  • user_id — int — NOT NULL
  • status — int — NOT NULL
  • read — int — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

screens

  • id — INT(10) — 기본 키 — NOT NULL
  • golf_time — DATETIME — NOT NULL
  • golf_store_code — VARCHAR(8) — NOT NULL
  • golf_store_region_name — VARCHAR(255) — NOT NULL
  • golf_store_id — INT(11) — NOT NULL
  • golf_store_name — VARCHAR(255) — NOT NULL
  • golf_partner — INT(11) — NOT NULL
  • golf_age — INT(11) — NOT NULL
  • golf_score — INT(11) — NOT NULL
  • golf_invite_type — INT(11) — NOT NULL
  • golf_after — VARCHAR(16) — NOT NULL
  • golf_sponsor — INT(11) — NOT NULL
  • game_fee — INT(11) — NOT NULL
  • message — VARCHAR(255) — NOT NULL
  • poster — VARCHAR(16) — NOT NULL
  • poster_id — INT(10) — NOT NULL
  • partner — VARCHAR(16)
  • partner_id — INT(10) — NOT NULL
  • view_count — INT(10) — NOT NULL
  • rsvps — INT(11) — NOT NULL
  • status — INT(11) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

screens_rsvps

  • id — INT(10) — 기본 키 — NOT NULL
  • id (screen_id) — INT(10) — 외래 키 → screens.id — NOT NULL
  • poster — VARCHAR(16) — NOT NULL
  • poster_id — INT(10) — NOT NULL
  • message — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP