카카오테크캠퍼스ERD

테이블 (6)

AISummary (Untitled6)

  • summary_id (Key) — 기본 키 — NOT NULL
  • document_page_id (Key2) — 외래 키 → DocumentPage.document_page_id — NOT NULL
  • summary_date (Field)
  • contents (Field2)

Document (Untitled3)

  • document_id (Key) — Long — 기본 키 — NOT NULL
  • folder_id (Key2) — Long — 외래 키 → Folder.folder_id — NOT NULL
  • name (Field)

DocumentPage (Untitled4)

  • document_page_id (Key2) — 기본 키 — NOT NULL
  • document_id (Key) — Long — 외래 키 → Document.document_id — NOT NULL
  • background (Field)
  • pageNumber (Field2)
  • contents (Field3)

Folder (Untitled2)

  • folder_id (Key) — Long — 기본 키 — NOT NULL
  • parent_id (Key2) — Long — 외래 키 → Folder.folder_id — NOT NULL
  • member_id (Key3) — Long — 외래 키 → Member.member_id — NOT NULL
  • name (Field)

Member (Untitled)

  • member_id (Key) — Long — 기본 키 — NOT NULL
  • email (Field)
  • password (Field2)

RecordInfo (Untitled5)

  • record_id (Key) — 기본 키 — NOT NULL
  • document_page_id (Key2) — 외래 키 → DocumentPage.document_page_id — NOT NULL
  • record_date (Field)
  • record_url (Field2)