1

Tables (4)

Logs (이용내역)

  • user (Key) — Foreign key → Users.id — NOT NULL
  • deer (Key2) — Foreign key → deers.id — NOT NULL
  • use_end_lat (Field) — Decimal
  • use_end_lng (decima) — Decimal
  • use_start_at (Field3) — Datetime
  • use_end_at (datetime) — Datetime
  • in_use (bool) — BOOL
  • fee (Int) — INT

Users (회원정보)

  • id (Key) — Primary key — NOT NULL
  • username (Field) — Char
  • password (Field2) — Char

areas (지역)

  • id (Key) — Primary key — NOT NULL
  • area_boundary (Field) — POLYGON
  • area_center (Field2) — POINT
  • area_coords (Field3) — ??
  • basic_fee (Int) — Int
  • fee_per_min (Field5) — Int

deers (퀵보드)

  • id (Key) — Primary key — NOT NULL
  • area (Key2) — Foreign key → areas.id — NOT NULL