KCR ERD

테이블 (15)

Abstract (CopyOfUntitled)

  • Seq_Abstract — 기본 키 — NOT NULL
  • Abstract No (Field31)
  • Scientific/Education (Field6)
  • Topic (Field12)
  • RSNA (Field13)
  • Case Report (Field14)
  • Copyright Agreement (Field15)
  • Presentation Type (Field16)
  • ISP (Field18)
  • Exhibition Awards (Field20)
  • Abstract_PA_ID(E-mail) (member_seq) — 외래 키 → Member.ID(E-mail) — NOT NULL
  • Abstract_PA (Key3) — 외래 키 → Presenting Author.Seq_PA — NOT NULL
  • Abstract_Coauthor (Key) — 외래 키 → Co-Author.Seq_coauthor — NOT NULL
  • Abstract_CA (Key4) — 외래 키 → Corresponding Author.Seq_CA — NOT NULL
  • Abstract_Preview (Key2) — 외래 키 → Abstract Preview.Seq_preview — NOT NULL

Abstract Preview (CopyOfCopyOfUntitled)

  • Seq_preview (Key) — 기본 키 — NOT NULL
  • Abstract Title (Field21)
  • Content (Field22)
  • Purpose (Field23)
  • Materials and Method (Field24)
  • Result (Field25)
  • Conclusion (Field26)

Affiliation (CopyOfCopyOfCopyOfUntitled3)

  • Seq_Affiliation (Key) — 기본 키 — NOT NULL
  • Kor_Affiliation (Field3)
  • Eng_Affiliation (Field11)
  • Affiliation Category (Field4)
  • Affiliation Address (Field)
  • Postal Code (Field2)

Category (CopyOfCopyOfUntitled3)

  • Seq_Category (Key) — 기본 키 — NOT NULL
  • Category (Field3)
  • Category Other (Field11)

Co-Author (Untitled2)

  • Seq_coauthor (Key) — 기본 키 — NOT NULL
  • First Name (Field)
  • Last Name (Field2)
  • Affiliation (Field3)
  • Department (Field4)
  • Order (Field5)

Corresponding Author (CopyOfUntitled2)

  • Seq_CA (Key) — 기본 키 — NOT NULL
  • Name (Field)
  • Phone Number (Field2)
  • E-mail (Field3)

Degree (CopyOfUntitled3)

  • Seq_Degree (Key) — 기본 키 — NOT NULL
  • Degree(학위) (Field3)
  • Degree Other (Field11)

Department (CopyOfCopyOfCopyOfCopyOfUntitled32)

  • Seq_Department (Key) — 기본 키 — NOT NULL
  • Depth (Field3)
  • Department (Field11)
  • Department Other (Field)

Fee (Untitled4)

  • Seq_fee (Key) — 기본 키 — NOT NULL
  • 회차 (Field3)
  • 구분 (Field)
  • 금액 (Field2)

Member (Untitled)

  • ID(E-mail) (member_seq) — 기본 키 — NOT NULL
  • Country (Field19)
  • Password (member_pw)
  • First Name (Field)
  • Last Name (Field4)
  • Name(국문) (Field5)
  • Date of Birth (Field12)
  • Affiliation Direct (Field2)
  • Home Postal Code (Field15)
  • Home Address (Field16)
  • Mobile Phone Number (Field3)
  • Licence No (Field17)
  • Post Agreement (Field18)
  • Member_Title (Key3) — 외래 키 → Title.Seq_Title — NOT NULL
  • Member_Degree (Key) — 외래 키 → Degree.Seq_Degree — NOT NULL
  • Member_Category (Key2) — 외래 키 → Category.Seq_Category — NOT NULL
  • Member_Affiliation (Key4) — 외래 키 → Affiliation.Seq_Affiliation — NOT NULL
  • Member_Department (Key6) — 외래 키 → Department.Seq_Department — NOT NULL
  • Member_Specialty (Key5) — 외래 키 → Specialty.Seq_Specialty — NOT NULL
  • Member_Invited (Key7) — 외래 키 → 초청연사.Seq_Invited — NOT NULL

Presenting Author (CopyOfCopyOfUntitled2)

  • Seq_PA (Key) — 기본 키 — NOT NULL
  • Country (Field19)
  • E-mail (Field27)
  • First Name (Field)
  • Last Name (Field4)
  • Name(국문) (Field5)
  • Mobile Phone Number (Field2)
  • Licence No (Field17)
  • 발표자_ID(E-mail) (member_seq) — 외래 키 → Registration.ID(E-mail) — NOT NULL
  • Seq_Title (Key3) — 외래 키 → Title.Seq_Title — NOT NULL
  • Seq_Degree (Key4) — 외래 키 → Degree.Seq_Degree — NOT NULL
  • Seq_Affiliation (Key2) — 외래 키 → Affiliation.Seq_Affiliation — NOT NULL
  • Seq_Department (Key5) — 외래 키 → Department.Seq_Department — NOT NULL

Registration (Untitled3)

  • ID(E-mail) (member_seq) — 외래 키 → Member.ID(E-mail) — NOT NULL
  • Registration No (Field)
  • 동반인 (Field11)
  • Refresher Courses Syllabus (Field3)
  • 특이식단 (Field4)
  • R&E 참여여부 (Field5)
  • 사업내용 (Field6)
  • 사업내용 기타 (Field7)
  • 결제방법 (Field8)
  • Payment Suatus (Field9)
  • Registration_Fee (Key2) — 외래 키 → Fee.Seq_fee — NOT NULL

Specialty (CopyOfCopyOfCopyOfUntitled32)

  • Seq_Specialty (Key) — 기본 키 — NOT NULL
  • Depth (Field3)
  • Specialty (Field11)
  • Specialty Other (Field)

Title (CopyOfCopyOfUntitled32)

  • Seq_Title (Key) — 기본 키 — NOT NULL
  • Title (Field3)
  • Title Other (Field11)

초청연사 (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled32)

  • Seq_Invited (Key) — 기본 키 — NOT NULL
  • E-mail (Field3)