tetst
Tables (10)
custom_names
- member_id — BIGINT — Primary key — NOT NULL
- contact_member_id — BIGINT — Primary key — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- name — VARCHAR(50)
group_members
- id — BIGSERIAL
- group_id — BIGINT — NOT NULL
- member_id — BIGINT — NOT NULL
- joined_at — TIMESTAMP — NOT NULL
groups
- id — BIGSERIAL
- owner_id — BIGINT
- name — VARCHAR(50) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP — NOT NULL
members
- id — BIGSERIAL
- user_id — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- state — SMALLINT — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- reactivation_date — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
message_recipients
- id — BIGSERIAL
- sent_id — BIGINT — NOT NULL
- recipient_id — BIGINT
- is_deleted — BOOLEAN — NOT NULL
- is_read — BOOLEAN — NOT NULL
- read_at — TIMESTAMP
messages
- id — BIGSERIAL
- writer_id — BIGINT
- is_treasure — Boolean — NOT NULL
- title — VARCHAR(50)
- content — TEXT
- image — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
messages_sent
- id — BIGSERIAL
- sender_id — BIGINT
- message_id — BIGINT
- is_deleted — BOOLEAN — NOT NULL
- is_public — BOOLEAN — NOT NULL
- to_group — BIGINT
- sent_at — TIMESTAMP — NOT NULL
notifications
- id — BIGSERIAL
- content — TEXT — NOT NULL
- member_id — BIGINT
- title — VARCHAR(50) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
treasure_messages
- id — BIGSERIAL
- message_id — BIGINT — NOT NULL
- hint_image — VARCHAR(255) — NOT NULL
- hint_vector — VECTOR(12288) — NOT NULL
- hint_text — VARCHAR(100)
- dot_hint_image — VARCHAR(255) — NOT NULL
- coordinate — VECTOR(2) — NOT NULL
- found_by — BIGINT
- found_at — TIMESTAMP
user_reports
- id — BIGSERIAL
- reporter_id — BIGINT
- reported_id — BIGINT
- recep_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- state — SMALLINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL