Meetty

Tables (5)

notifications

  • notification_id (Key2) — BIGITNT — Primary key — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMP
  • study_id (Key3) — BIGINT — Foreign key → studies.study_id — NOT NULL
  • user_id (Key) — BIGINT — Foreign key → users.user_id — NOT NULL

refresh_token (Untitled2)

  • token_id (Key) — bigint — Primary key — NOT NULL
  • refresh_token (Field) — varchar(255) — NOT NULL
  • expiration (Field2) — timestamp
  • user_id (Key2) — BIGINT — Foreign key → users.user_id — NOT NULL

studies

  • study_id (Key) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • region — VARCHAR(100)
  • category — VARCHAR(50)
  • max_member_count — INT
  • current_member_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_images (Untitled)

  • user_image_id (Key) — bigint — Primary key — NOT NULL
  • url (Field) — varchar(255) — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → users.user_id — NOT NULL

users

  • user_id (Key) — BIGINT — Primary key — NOT NULL
  • email — VARCAHR(30) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • username — VARCHAR(20) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • provider — VARCHAR(20)
  • provider_id — VARCHAR(100)
  • role — VARCHAR(20) — NOT NULL