MoLLU

Tables (12)

black

  • black_id — string — Primary key — NOT NULL
  • member_id — string — Foreign key → member.member_id — NOT NULL
  • black_member_id (member_id2) — string — Foreign key → member.member_id — NOT NULL

comment

  • comment_id — string — Primary key — NOT NULL
  • content (message) — string
  • content_id — string — Foreign key → content.content_id — NOT NULL

comment_report

  • report_id — string — Primary key — NOT NULL
  • reason — string — NOT NULL
  • member_id — string — Foreign key → member.member_id — NOT NULL
  • comment_id — string — Foreign key → comment.comment_id — NOT NULL

content

  • content_id — string — Primary key — NOT NULL
  • public — boolean — NOT NULL
  • location — string
  • content_tag — string
  • front_content_source — string — NOT NULL
  • back_content_source — string

content_group

  • content_group_id — string — Primary key — NOT NULL
  • content_id — string — Foreign key → content.content_id — NOT NULL
  • group_id (group_id2) — string — Foreign key → group.group_id — NOT NULL

content_report

  • report_id — string — Primary key — NOT NULL
  • reason — string — NOT NULL
  • member_id — string — Foreign key → member.member_id — NOT NULL
  • content_id — string — Foreign key → content.content_id — NOT NULL

feedback (Feedback)

  • feedback_id — string — Primary key — NOT NULL
  • type — string — NOT NULL
  • feedbackSrc (feedback_source) — string — NOT NULL
  • content_id — string — Foreign key → content.content_id — NOT NULL

group

  • group_id — string — Primary key — NOT NULL
  • name — string — NOT NULL
  • introduction — string
  • public — boolean — NOT NULL
  • group_profile_source (Field) — string
  • invitation_id — string — Foreign key → invitation.invitation_id — NOT NULL

invitation

  • invitation_id — string — Primary key — NOT NULL
  • code — string
  • expiration — date

member

  • member_id — string — Primary key — NOT NULL
  • name — string — NOT NULL
  • molluId — string — NOT NULL
  • birthday — date — NOT NULL
  • preference_id — string — Foreign key → preference.preference_id — NOT NULL

preference

  • preference_id — string — Primary key — NOT NULL
  • captureAlarm (capture_alarm) — boolean — NOT NULL
  • contentAlarm (content_alarm) — boolean — NOT NULL
  • commentAlarm (comment_alarm) — boolean — NOT NULL

relation

  • id — string — Primary key — NOT NULL
  • role — string — NOT NULL
  • member_id — string — Foreign key → member.member_id — NOT NULL
  • group_id — string — Foreign key → group.group_id — NOT NULL