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