erd.txt

# Visualize on https://erd.surge.sh
# or https://quick-erd.surge.sh
#
# Relationship Types
#  -    - one to one
#  -<   - one to many
#  >-   - many to one
#  >-<  - many to many
#  -0   - one to zero or one
#  0-   - zero or one to one
#  0-0  - zero or one to zero or one
#  -0<  - one to zero or many
#  >0-  - zero or many to one
#
////////////////////////////////////


user
----
id integer PK
email varchar(64)
password varchar(64)
role USER-DEFINED


users_categories
----------------
id integer PK
user_id integer NULL FK >- user.id
category_id integer NULL FK >- category.id


participants_events
-------------------
id integer PK
user_id integer NULL FK >- user.id
event_id integer NULL FK >- event.id
message text NULL


event
-----
id integer PK
name varchar(255) NULL
creator_id integer NULL FK >- user.id
event_date date NULL
event_time time NULL
agency varchar(64) NULL
venue varchar(255) NULL
vacancy integer NULL
quota integer NULL
status USER-DEFINED NULL
category_id integer NULL FK >- category.id
about text NULL
contact text NULL
user_create_event_image varchar(255) NULL


category
--------
id integer PK
name varchar(60) NULL
image varchar(255) NULL
user_image varchar(255) NULL