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