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