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