논문

테이블 (4)

Document Table (tb_doc)

  • Doc ID (DOC_ID) — INT — 기본 키 — NOT NULL
  • Folder ID (FOLDER_ID) — INT — 외래 키 → Folder Table.Folder ID — NOT NULL
  • User ID (USER_ID) — VARCHAR(255) — 외래 키 → Folder Table.User ID — NOT NULL
  • Recommend_ID (RECOMMEND_ID) — INT
  • Doc Name (DOC_NAME) — VARCHAR(255)
  • Create Date (CREDATE) — DATETIME
  • Status (STATUS) — INT

Folder Table (tb_folder)

  • Folder ID (FOLDER_ID) — INT — 기본 키 — NOT NULL
  • User ID (USER_ID) — VARCHAR(255) — 외래 키 → User Table.User ID — NOT NULL
  • Model ID (MODEL_ID) — INT — 외래 키 → Model Table.Model ID — NOT NULL
  • Folder Name (FOLDER_NAME) — VARCHAR(255)
  • Status (STATUS) — INT
  • Parent ID (PARENT_ID) — INT — 외래 키 → Folder Table.Folder ID — NOT NULL

Model Table (tb_model)

  • Model ID (MODEL_ID) — INT — 기본 키 — NOT NULL
  • Model Path (MODEL_PATH) — VARCHAR(255)

User Table (tb_user)

  • User ID (USER_ID) — VARCHAR(255) — 기본 키 — NOT NULL
  • User Name (USER_NAME) — VARCHAR(255)
  • Password (PASSWORD) — VARCHAR(255)
  • Root File Path (ROOT_FILE_PATH) — VARCHAR(255)