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