puly

Tables (8)

chat_room_members

  • id — SERIAL
  • chat_room_id — INTEGER — NOT NULL
  • user_id — INTEGER — NOT NULL
  • joined_at — TIMESTAMP

chat_rooms

  • id — SERIAL
  • is_group — BOOLEAN
  • name — TEXT
  • created_by — INTEGER
  • created_at — TIMESTAMP

contact_books

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • name — TEXT
  • phone_number — TEXT — NOT NULL
  • synced_at — TIMESTAMP

friendships

  • id — Primary key — NOT NULL
  • user_id — Foreign key → users.id — NOT NULL
  • friend_id — INTEGER — NOT NULL
  • status — TEXT — NOT NULL
  • created_at — TIMESTAMP

location_logs

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • accuracy — FLOAT
  • status — TEXT
  • recorded_at — TIMESTAMP

messages

  • id — SERIAL
  • chat_room_id — INTEGER — NOT NULL
  • sender_id — INTEGER — NOT NULL
  • type — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

push_tokens

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • token — TEXT — NOT NULL
  • device_info — TEXT
  • updated_at — TIMESTAMP

users

  • id — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • nickname — TEXT — NOT NULL
  • phone_number — TEXT — NOT NULL
  • email — TEXT
  • provider — TEXT — NOT NULL
  • provider_id — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP