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)