momo
Tables (10)
attendance
- id — bigint — Primary key — NOT NULL
- is_attend — boolean — NOT NULL
- user_id — bigint — NOT NULL
- group_id — bigint
- schedule_id — bigint
comment
- id — bigint — Primary key — NOT NULL
- created_date — timestamp
- last_modified_date — timestamp
- contents — longtext
- post_id — bigint
- user_id — bigint
district
- id — bigint — Primary key — NOT NULL
- city — varchar(255) — NOT NULL
- district_name — varchar(255) — NOT NULL
favorite_category
- id — bigint — Primary key — NOT NULL
- category — varchar(255)
- user_id — bigint
groups
- id — bigint — Primary key — NOT NULL
- created_date — timestamp
- last_modified_date — timestamp
- category — varchar(255)
- city — varchar(255)
- district — varchar(255)
- image_url — varchar(255)
- introduction — longtext
- is_end — boolean — NOT NULL
- is_offline — boolean — NOT NULL
- name — varchar(255)
- recruitment_cnt — integer — NOT NULL
- start_date — date
- university — varchar(255)
- manager_id — bigint
image
- id — bigint — Primary key — NOT NULL
- image_url — varchar(255)
- post_id — bigint
participant
- id — bigint — Primary key — NOT NULL
- created_date — timestamp
- last_modified_date — timestamp
- group_id — bigint
- user_id — bigint
post
- id — bigint — Primary key — NOT NULL
- created_date — timestamp
- last_modified_date — timestamp
- contents — longtext
- title — varchar(255)
- type — varchar(255)
- author_id — bigint
- group_id — bigint
schedule
- id — bigint — Primary key — NOT NULL
- created_date — timestamp
- last_modified_date — timestamp
- attendance_check — boolean — NOT NULL
- contents — longtext
- is_offline — boolean — NOT NULL
- start_date_time — timestamp
- title — varchar(255)
- author_id — bigint
- group_id — bigint
user
- id — bigint — Primary key — NOT NULL
- created_date — timestamp
- last_modified_date — timestamp
- city — varchar(255)
- district — varchar(255)
- image_url — varchar(255)
- nickname — varchar(255)
- provider — varchar(255)
- provider_id — varchar(255) — NOT NULL
- refresh_token — varchar(255)
- university — varchar(255)