ERD
Tables (7)
Advertisements
- ad_id — INT
- image_url — VARCHAR(255) — NOT NULL
- link_url — VARCHAR(255) — NOT NULL
- start_date — DATETIME
- end_date — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
Artists
- artist_id — INT
- name — VARCHAR(255) — NOT NULL
- group_name — VARCHAR(255)
- description — TEXT
- profile_image — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
Events
- event_id — INT
- artist_id — INT — NOT NULL
- created_by — INT — NOT NULL
- map_id — INT
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- start_datetime — DATETIME — NOT NULL
- end_datetime — DATETIME — NOT NULL
- is_deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
Favorites
- favorite_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- created_at — DATETIME
Maps
- map_id — INT
- name — VARCHAR(255) — NOT NULL
- lat — DECIMAL(10,7) — NOT NULL
- long — DECIMAL(10,7) — NOT NULL
- address — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
Notifications
- notification_id — INT
- user_id — INT — NOT NULL
- event_id — INT — NOT NULL
- notification_type — VARCHAR(50)
- status — VARCHAR(50)
- sent_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
Users
- user_id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- profile_image — VARCHAR(255)
- role — ENUM('admin','user') — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- social_provider — VARCHAR(50)
- social_id — VARCHAR(50)
- invitation_code — VARCHAR(50)