테스트

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