테스트
테이블 (13)
entry_auth_request
- auth_request_id — VARCHAR(80) — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id
- franchise_id — BIGINT — 외래 키 → franchise.franchise_id — NOT NULL
- phone_number — VARCHAR(30) — NOT NULL
- store_name — VARCHAR(100)
- auth_code — VARCHAR(20) — NOT NULL
- sent — BOOLEAN — NOT NULL
- verified — BOOLEAN — NOT NULL
- expires_at — DATETIME — NOT NULL
- verified_at — DATETIME
- created_at — DATETIME — NOT NULL
franchise
- franchise_id — BIGINT — 기본 키 — NOT NULL
- franchise_name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
kiosk_auth_session
- kiosk_auth_session_id — BIGINT — 기본 키 — NOT NULL
- franchise_id — BIGINT — 외래 키 → franchise.franchise_id — NOT NULL
- device_name — VARCHAR(100)
- access_channel — VARCHAR(30) — NOT NULL
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- expires_at — DATETIME
member
- member_id — BIGINT — 기본 키 — NOT NULL
- phone_number — VARCHAR(30) — NOT NULL
- member_name — VARCHAR(100)
- agree_bio — BOOLEAN — NOT NULL
- face_registered — BOOLEAN — NOT NULL
- inside — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
member_ticket_session
- ticket_session_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- franchise_id — BIGINT — 외래 키 → franchise.franchise_id — NOT NULL
- seat_id — BIGINT — 외래 키 → seat.seat_id
- current_ticket_expires_at — DATETIME
- final_ticket_expires_at — DATETIME
- remaining_minutes — INT
- remaining_days — INT
- has_usable_balance — BOOLEAN — NOT NULL
- inside — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
parking_discount_item
- discount_item_id — VARCHAR(80) — 기본 키 — NOT NULL
- parking_site_id — VARCHAR(80) — 외래 키 → parking_site.parking_site_id — NOT NULL
- parking_store_id — VARCHAR(80) — 외래 키 → parking_store.parking_store_id — NOT NULL
- discount_item_name — VARCHAR(100) — NOT NULL
- discount_minutes — INT — NOT NULL
- credit_type — VARCHAR(30)
- credit_amount — INT
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
parking_discount_use
- discount_item_use_id — VARCHAR(80) — 기본 키 — NOT NULL
- parking_vehicle_id — VARCHAR(120) — 외래 키 → parking_vehicle.parking_vehicle_id — NOT NULL
- discount_item_id — VARCHAR(80) — 외래 키 → parking_discount_item.discount_item_id — NOT NULL
- parking_store_id — VARCHAR(80) — 외래 키 → parking_store.parking_store_id — NOT NULL
- apply_type — VARCHAR(20) — NOT NULL
- apply_count — INT — NOT NULL
- applied_count — INT
- discount_use_state — VARCHAR(30)
- memo — VARCHAR(255)
- applied_at — DATETIME — NOT NULL
- canceled_at — DATETIME
parking_member_check_log
- parking_member_check_log_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id
- franchise_id — BIGINT — 외래 키 → franchise.franchise_id — NOT NULL
- phone_number — VARCHAR(30) — NOT NULL
- eligible — BOOLEAN — NOT NULL
- inside — BOOLEAN — NOT NULL
- reason — VARCHAR(50)
- entered_at — DATETIME
- elapsed_minutes — INT
- created_at — DATETIME — NOT NULL
parking_site
- parking_site_id — VARCHAR(80) — 기본 키 — NOT NULL
- site_name — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
parking_store
- parking_store_id — VARCHAR(80) — 기본 키 — NOT NULL
- parking_site_id — VARCHAR(80) — 외래 키 → parking_site.parking_site_id — NOT NULL
- franchise_id — BIGINT — 외래 키 → franchise.franchise_id
- store_name — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
parking_vehicle
- parking_vehicle_id — VARCHAR(120) — 기본 키 — NOT NULL
- parking_site_id — VARCHAR(80) — 외래 키 → parking_site.parking_site_id — NOT NULL
- in_id — VARCHAR(80) — NOT NULL
- in_order_id — VARCHAR(80) — NOT NULL
- plate_number — VARCHAR(30) — NOT NULL
- plate_number4 — VARCHAR(4) — NOT NULL
- in_time — DATETIME
- in_gate_name — VARCHAR(100)
- workflow_state — VARCHAR(50)
- out_time — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
seat
- seat_id — BIGINT — 기본 키 — NOT NULL
- franchise_id — BIGINT — 외래 키 → franchise.franchise_id — NOT NULL
- seat_name — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
tablet_phone_entry_log
- tablet_phone_entry_log_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id
- franchise_id — BIGINT — 외래 키 → franchise.franchise_id — NOT NULL
- seat_id — BIGINT — 외래 키 → seat.seat_id
- auth_request_id — VARCHAR(80) — 외래 키 → entry_auth_request.auth_request_id
- phone_number — VARCHAR(30) — NOT NULL
- access_channel — VARCHAR(30) — NOT NULL
- auth_required — BOOLEAN — NOT NULL
- inside — BOOLEAN — NOT NULL
- next_action — VARCHAR(50) — NOT NULL
- result_message — VARCHAR(255)
- created_at — DATETIME — NOT NULL