MonVi
Tables (15)
CHATTING_MSG (Untitled9)
- id (Key) — Primary key — NOT NULL
- send_member_id (Field)
- data (Field2)
- type (Field3)
- match_id (Key2) — Foreign key → MatchMon.id — NOT NULL
Comment (Untitled10)
- Key — Primary key — NOT NULL
- post_id (Key2) — Foreign key → Post.id — NOT NULL
- commenter_id (Key3) — Foreign key → Member.id — NOT NULL
- text (Field2)
HaveMon (Untitled2)
- id (Key) — Primary key — NOT NULL
- member_id (Key3) — Foreign key → Member.id — NOT NULL
- site_id (Field)
- date (Field2) — dateTime
Image (Untitled12)
- id (Key) — Primary key — NOT NULL
- path (Field)
Job (Untitled6)
- id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → Member.id — NOT NULL
- type (Field)
- title (Field2)
- description (Field3)
JobHaveMon (Untitled7)
- id (Key) — Primary key — NOT NULL
- job_id (Key2) — Foreign key → Job.id — NOT NULL
- have_mon_id (Key3) — Foreign key → HaveMon.id — NOT NULL
MatchMon (Untitled5)
- id (Key) — Primary key — NOT NULL
- job_id (Key2) — Foreign key → Job.id — NOT NULL
- req_member_id (Key3) — Foreign key → Member.id — NOT NULL
- status (Field)
- description (String)
Member (Untitled)
- id (Key) — Primary key — NOT NULL
- name (Field)
- email (Field2)
- platform (Field4)
- platformKey (Field3) — string
- role (Field5) — enum
Mon_Site (Untitled4)
- id (Key) — Primary key — NOT NULL
- location (Field)
- display_name (Field2)
- site_type (Field3)
Post (Untitled8)
- id (Key) — Primary key — NOT NULL
- poster_id (Key2) — Foreign key → Member.id — NOT NULL
- site (Field)
- title (Field2)
- text (Field3)
- view (Field4)
- like_count (Field5)
- dislike_count (Field6)
- complaint_count (Field7)
PostImage (Untitled11)
- id (Key) — Primary key — NOT NULL
- post_id (Key2) — Foreign key → Post.id — NOT NULL
- image_id (Key3) — Foreign key → Image.id — NOT NULL
- order (Field)
PostLike (Untitled13)
- id (Key) — Primary key — NOT NULL
- post_id (Key2) — Foreign key → Post.id — NOT NULL
- member_id (Key3) — Foreign key → Member.id — NOT NULL
PostReport (Untitled14)
- id (Key) — Primary key — NOT NULL
- post_id (Key3) — Foreign key → Post.id — NOT NULL
- member_id (Key2) — Foreign key → Member.id — NOT NULL
WantMon (Untitled3)
- id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → Member.id — NOT NULL
- site_id (Field)
- type (Field2)
- description (Field3)
- is_notified (Field4)
WantMonDate (WantMon)
- id (Key) — Primary key — NOT NULL
- want_mon_id (Key2) — Foreign key → WantMon.id — NOT NULL
- date1 (Field)
- date2 (Field2)