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