spit

Tables (18)

ATTACHMENTS (Untitled15)

  • id (Key) — uuid — Primary key — NOT NULL
  • owner_user_id (Field) — uuid
  • type (Field2) — text
  • url (Field3) — text
  • meta (Field4) — jsonb
  • created_at (Field5) — time

AUTH_TOKENS (Untitled2)

  • user_id (Field) — uuid
  • refresh_token_hash (Field2) — text
  • expires_at (Field3) — time
  • revoked_at (Field4) — time
  • create_at (Field5) — time

BADGES (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • code (Field) — text
  • label (Field2) — text
  • type (Field3) — text
  • Field4

CLUBS (Untitled8)

  • id (Key) — uuid — Primary key — NOT NULL
  • owner_user_id (Field) — uuid
  • name (Field2) — text
  • sport_id (Field3) — int
  • region_code (Field4) — text
  • schedule (Field5) — jsonb
  • target_size (Field6) — int
  • level_min (Field7) — text
  • level_max (Field8) — text
  • is_public (Field9) — bool
  • rating_avg (Field10) — numeric
  • created_at (Field11) — time

CLUB_APPLICATIONS (Untitled10)

  • id (Key) — uuid — Primary key — NOT NULL
  • club_id (Field) — uuid
  • user_id (Field2) — uuid
  • mode (Field3) — text
  • answers (Field4) — jsonb
  • status (Field5) — text
  • decided_by (Field6) — uuid
  • decided_at (Field7) — time
  • created_at (Field8) — time
  • unique_key (Field9) — text

CLUB_MEMBERS (Untitled9)

  • id (Key) — uuid — Primary key — NOT NULL
  • club_id (Field) — uuid
  • user_id (Field2) — uuid
  • role (Field3) — text
  • state (Field4) — text
  • joined_at (Field5) — time
  • unique_key (Field6) — text

DATASETS (Untitled17)

  • id (Key) — uuid — Primary key — NOT NULL
  • name (Field) — text
  • source (Field2) — text
  • version (Field3) — text
  • rows (Field4) — int
  • imported_at (Field5) — time
  • status (Field6) — text
  • log (Field7) — text

DATASETS_ROWS (Untitled18)

  • id (Key) — uuid — Primary key — NOT NULL
  • dataset_id (Field) — uuid
  • raw (Field2) — jsonb
  • vaild (Field3) — bool
  • mapped_table (Field4) — text
  • mapped_id (Field5) — uuid
  • error (Field6) — text

FALSH_ATTENDEES (Untitled12)

  • id (Key) — uuid — Primary key — NOT NULL
  • meetup_id (Field) — uuid
  • user_id (Field2) — uuid
  • state (Field3) — text
  • joined_at (Field4) — time
  • unique_key (Field5) — text

FLASH_MEETUPS (Untitled11)

  • id (Key) — uuid — Primary key — NOT NULL
  • name (Field) — text
  • host_user_id (Field2) — uuid
  • sport_id (Field3) — int
  • region_code (Field4) — text
  • start_at (Field5) — time
  • end_at (Field6) — time
  • place_text (Field7) — text
  • capacity (Field8) — int
  • stauts (Field9) — text
  • created_at (Field10) — time

NOTIFICATIONS (Untitled16)

  • id (Key) — uuid — Primary key — NOT NULL
  • user_id (Field) — uuid
  • type (Field2) — text
  • payload (Field3) — jsonb
  • read_at (Field4)
  • created_at (Field5)

PROFILES (Untitled3)

  • id (Key) — uuid — Primary key — NOT NULL
  • user_id (Field) — uuid
  • gender (Field2) — text
  • age (Field3) — int
  • region_code (Field4) — text
  • level (Field5) — text
  • sports (Field6) — int[]
  • bage_summary (Field7) — text
  • updated_at (Field8) — time

PROMOTIONS (Untitled14)

  • id (Key) — uuid — Primary key — NOT NULL
  • user_id (Field) — uuid
  • target_level (Field2) — text
  • evidences (Field3) — josnb
  • stauts (Field4) — text
  • decided_by (Field5) — uuid
  • decided_at (Field6) — time
  • created_at (Field7) — time

REGIONS (Untitled5)

  • code (Key) — text — Primary key — NOT NULL
  • name (Field) — text
  • parent_code (Field2)

REVIEWS (Untitled13)

  • idc (Key) — uuid — Primary key — NOT NULL
  • club_id (Field) — uuid
  • writer_usert_id (Field2) — uuid
  • rating (Field3) — int
  • manners (Field4) — int
  • comment (Field5) — text
  • create_at (Field6) — time

SPORTS (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • name (Field) — text
  • active (Field2) — bool

USERES (Untitled)

  • id (Key) — uuid — Primary key — NOT NULL
  • email (Field) — text
  • password_hash (Field2) — text
  • role (Field3) — text
  • create_at (Field4) — time
  • stauts (Field5) — text

USER_BADGES (Untitled7)

  • id (Key) — uuid — Primary key — NOT NULL
  • user_id (Field) — uuid
  • badge_id (Field2) — int
  • granted_at (Field3) — time
  • unique_key (Field4) — text