HomeComingDay

Tables (15)

Article (Articles)

  • ArticleId (Key) — Long — Primary key — NOT NULL
  • MemberId (Key2) — Long — Foreign key → Member.MemberId — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • views (Field3) — Long
  • articleFlag (Field4) — Enum
  • createdAt (Field5) — String
  • mDate (Field6) — String
  • mTime (Field7) — String
  • place (Field8) — String

Article (CopyOfArticles)

  • ArticleId (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • views (Field3) — Long
  • articleFlag (Field4) — Enum
  • createdAt (Field5) — String
  • mDate (Field6) — String
  • mTime (Field7) — String
  • place (Field8) — String

Comment (CopyOfUntitled62)

  • Commentid (Key) — Long — Primary key — NOT NULL
  • ArticleId (Key2) — Long — Foreign key → Article.ArticleId — NOT NULL
  • MemberId (Key3) — Long — Foreign key → Member.MemberId — NOT NULL
  • content (Field) — String
  • articleFlag (Field2) — Enum

Comment (CopyOfCopyOfUntitled62)

  • Commentid (Key) — Long — Primary key — NOT NULL
  • content (Field) — String
  • articleFlag (Field2) — Enum

Member (CopyOfUntitled)

  • MemberId (Key) — Long — Primary key — NOT NULL
  • userName (Key2) — String — NOT NULL
  • email (Field3) — String
  • admission (Field) — String
  • schollName (Key3) — String — NOT NULL
  • departmentName (Key4) — String — NOT NULL
  • password (Field2) — String

Member (CopyOfCopyOfUntitled)

  • MemberId (Key) — Long — Primary key — NOT NULL
  • userName (Key2) — String — NOT NULL
  • email (Field3) — String
  • admission (Field) — String
  • schollName (Key3) — String — NOT NULL
  • departmentName (Key4) — String — NOT NULL
  • password (Field2) — String

UniversityName (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • universityName (Key2) — String — NOT NULL

freeComment (CopyOfCopyOfUntitled6)

  • freeTalkCommentid (Key) — Long — Primary key — NOT NULL
  • helpId (Key2) — Long — Foreign key → freeTalk.freeId — NOT NULL
  • memberId (Key22) — Long — Foreign key → freeTalk.memberId — NOT NULL
  • content (Field) — String

freeTalk (CopyOfUntitled23)

  • freeId (Key) — Long — Primary key — NOT NULL
  • memberId (Key2) — Long — Foreign key → member.id — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • views (Field3) — Long

help (Untitled2)

  • helpId (Key) — Long — Primary key — NOT NULL
  • memberId (Key2) — Long — Foreign key → member.id — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • views (Field3) — Long

helpComment (Untitled6)

  • helpCommentid (Key) — Long — Primary key — NOT NULL
  • helpId (Key2) — Long — Foreign key → help.helpId — NOT NULL
  • memberId (Key22) — Long — Foreign key → help.memberId — NOT NULL
  • content (Field) — String

image (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • ArticleId (Key2) — Long — Foreign key → Article.ArticleId — NOT NULL
  • MemberId (Key22) — Long — Foreign key → Article.MemberId — NOT NULL
  • urlPath (Field) — String
  • imgUrl (Field2) — String
  • articleName (Field3) — String

information (CopyOfUntitled22)

  • informationId (Key) — Long — Primary key — NOT NULL
  • memberId (Key2) — Long — Foreign key → member.id — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • views (Field3) — Long

informationComment (CopyOfUntitled6)

  • inforamationid (Key) — Long — Primary key — NOT NULL
  • helpId (Key2) — Long — Foreign key → information.informationId — NOT NULL
  • memberId (Key22) — Long — Foreign key → information.memberId — NOT NULL
  • content (Field) — String

member (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • userName (Key2) — String — NOT NULL
  • email (Field3) — String
  • admission (Field) — String
  • schollName (Key3) — String — NOT NULL
  • departmentName (Key4) — String — NOT NULL
  • password (Field2) — String