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)