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)