ERD_TRY
Tables (13)
Community (Untitled4)
- doc_id (PK) — Primary key — NOT NULL
- user_id (FK) — Primary key — NOT NULL
- announcement (Field)
- content (Field2)
- category (Field3)
- is_main_announce (Field4)
- reg_date (Field5)
- mod_date (Field6)
Document (Untitled5)
- saved_doc_hash_ke (PK) — Primary key — NOT NULL
- doc_title (Field)
- topic (Field2)
- keyword (Field3)
- publish_institution_id (Field4)
- saved_doc_date (Field5)
- publish_Id (Field7)
- doc_type_Id (Field8)
File (Untitled6)
- file_id (PK) — Primary key — NOT NULL
- file_content_id (FK) — Primary key — NOT NULL
- file_name (Field)
- file_download_url (Field2)
Post (Untitled)
- hash_key (PK) — Primary key — NOT NULL
- writer_id (FK) — Primary key — NOT NULL
- category_id (FK2) — Primary key — NOT NULL
- post_body (Field)
- abstract (Field2)
- original_url (Field3)
- post_title (Field4)
- post_date (Field5)
User (Untitled3)
- id (PK) — Primary key — NOT NULL
- institution_id (FK) — Primary key — NOT NULL
- title_id (FK2) — Primary key — NOT NULL
- email (Field)
- user_email (Field2)
- name (Field3)
- registered_date (Field4)
community_post (Many-to-many)
- doc_id (PK) — Primary key — NOT NULL
- hash_key (PK2) — Primary key — NOT NULL
file_post (for matching)
- file_content_id (PK) — Primary key — NOT NULL
- hash_key (PK2) — Primary key — NOT NULL
institution (Untitled8)
- institution_id (PK) — Primary key — NOT NULL
- institution (Field)
publish_institution (Untitled11)
- id (PK) — Primary key — NOT NULL
- published_institution (Field)
- publish_institution_url (Field2)
title (Untitled9)
- title_id (PK) — Primary key — NOT NULL
- title (Field)
top_category (Untitled2)
- category_id (PK) — Primary key — NOT NULL
- top_category (Field)
user_post (Untitled10)
- writer_id (PK) — Primary key — NOT NULL
- id (PK2) — Primary key — NOT NULL
writer (Untitled7)
- writer_id (PK) — Primary key — NOT NULL
- post_writer (Field)