스크린
테이블 (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