DB_Project1
Tables (6)
AuthStatus
- status — MEDIUMTEXT
- userId (userId2) — VARCHAR(30) — Foreign key → UserInfo.userId — NOT NULL
DocumentInfo
- docId — INT — Primary key — NOT NULL
- doc_type — VARCHAR(10)
- doc_title — MEDIUMTEXT
- original_url — VARCHAR(512)
- file_download_url — MEDIUMTEXT
- file_name — VARCHAR(512)
- file_id_in_fsfiles — VARCHAR(30)
- file_extracted_content — MEDIUMTEXT
- postId — INT — Foreign key → PostInfo.postId — NOT NULL
PostContent
- post_body — MEDIUMTEXT
- postId — INT — Foreign key → PostInfo.postId — NOT NULL
PostInfo
- postId — INT — Primary key — NOT NULL
- post_title — VARCHAR(255)
- post_date — VARCHAR(15)
- post_writer — VARCHAR(255)
PostMetadata
- keyword — VARCHAR(255)
- category — VARCHAR(10)
- top_category — VARCHAR(50)
- first_char_title — VARCHAR(10)
- postId — INT — Foreign key → PostInfo.postId — NOT NULL
UserInfo
- userId — VARCHAR(30) — Primary key — NOT NULL
- userName — VARCHAR(30)
- savedUserName — VARCHAR(255)
- savedUserEmail — VARCHAR(255)
- email — MEDIUMTEXT
- isAdmin — TINYINT
- isApiUser — TINYINT
- isActive — TINYINT
- inst — MEDIUMTEXT
- name — MEDIUMTEXT