db_19

Tables (7)

Announcement

  • userName (Field) — varchar(30)
  • title (Field2) — varchar(128)
  • content (Field3) — text
  • isMainAnnounce (Field4) — tinyint
  • regDate (Field5) — datetime
  • modeDate (Field6) — datetime

DOC (DOC)

  • hash_key (PK) — Primary key — NOT NULL
  • savedDocHashKey (FK) — Foreign key → POST.hash_key — NOT NULL
  • doc_title (Field)
  • doc_type (Field2)
  • docUrl (Field3)
  • keyword (Field4)
  • first_char_title (Field5)
  • top_category (Field6)
  • abstract (Field7)
  • savedDocHashKey (Field8)

FAQ

  • category (Field) — varchar((10)
  • title (Field2) — varchar(128)
  • content (Field3) — text

File

  • file_download_url (FK) — original_url{POST) — Foreign key → POST.hash_key — NOT NULL
  • file_name (Field)
  • file_id_in_fsfiles (Field2)
  • file_extracted_contents (Field3)

POST

  • hash_key (PK) — Primary key — NOT NULL
  • post_title (Field)
  • post_body (Field2)
  • post_writer (Field3)
  • published_institution (Field4)
  • published_institution_url (Field5)
  • topic (Field7)
  • timestamp (Field8)
  • original_url (Field6)

QNA

  • category (Field)
  • question (Field2)
  • answer (Field3)
  • modifiedDate (Field4)
  • registerDate (Field5)
  • savedUserName (Field6)
  • savedUserEmail (Field7)

User

  • userId (PK) — varchar(30) — Primary key — NOT NULL
  • isAdmin (Field) — tinyint
  • isApiUser (Field2) — tinyint
  • isActive (Field3) — tinyint
  • name (Field4) — mediumtext
  • email (Field5) — mediumtext
  • inst (Field6) — mediumtext
  • status (Field7) — mediumtext