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)