슬개생

테이블 (5)

BASE_INFO (Base Information)

  • REC_ID (Record ID) — Number — 기본 키 — NOT NULL
  • WRT_SEQ (Writing Sequence) — Number — 기본 키 — NOT NULL
  • SEX (Sex) — VARCHAR2(1)
  • BIRTH_YEAR (Birth Year) — Date
  • EXP_YEAR (Experience Year) — Date
  • GROUP_CD (Group) — VARCHAR2(3)
  • GROUP_CNTE (Group(Contents)) — VARCHAR2(500)
  • MED_SERVICE_CD (Medical Service) — VARCHAR2(3)
  • MED_SERVICE_CNTE (Medical Service(Contents)) — VARCHAR2(500)
  • INSURANCE (Insurance) — VARCHAR2(3)
  • INSURANCE_CNTE (Insurance(Contents)) — VARCHAR2(500)
  • MEMBER_ID (Added Member Id) — VARCHAR2(5)

DETAIL_CODE (DETAIL CODE)

  • CODE (Code) — VARCHAR2(5) — 기본 키 — NOT NULL
  • TYPE (Type2) — VARCHAR2(5) — 외래 키 → TYPE_CODE.TYPE — NOT NULL
  • CODE_NAME (Code Name) — VARCHAR2(4000)
  • USE_YN (Use Yes Or No) — VARCHAR2(1)

HOSPITAL_INFO (Hospital Information)

  • REC_ID (Record ID) — Number — 외래 키 → BASE_INFO.REC_ID — NOT NULL
  • WRT_SEQ (Writing Sequence) — Number — 외래 키 → BASE_INFO.WRT_SEQ — NOT NULL
  • NATL_CD (National Code) — VARCHAR2(5)
  • RGN_CD (Region Code) — VARCHAR2(5)
  • EXP_YEAR (Experience Year) — Date
  • MAP_LINK (Google Map Link) — VARCHAR2(100)
  • MED_PRBLM_CNTE (Medical Problem Content) — VARCHAR2(4000)
  • MED_DEPT_CD (Medical Department Code) — VARCHAR2(5)
  • ENG_YN (English Yes Or No) — VARCHAR2(1)
  • COST (Cost) — NUMBER
  • IMG_LINK (Image Link) — VARCHAR2(4000)
  • RECOMMEND_SCR (Recommendation Score) — NUMBER

HOSPITAL_INFO_DTL (Hospital Information Detail)

  • WRT_SEQ (Writing Sequence) — Number — 외래 키 → HOSPITAL_INFO.WRT_SEQ — NOT NULL
  • REC_ID (Record ID) — Number — 외래 키 → HOSPITAL_INFO.REC_ID — NOT NULL
  • TYPE (Type2) — VARCHAR2(5) — 외래 키 → DETAIL_CODE.TYPE — NOT NULL
  • CODE (Code2) — VARCHAR2(5) — 외래 키 → DETAIL_CODE.CODE — NOT NULL
  • REC_CNTE (Record Etcetera Content) — VARCHAR2(4000)

TYPE_CODE (TYPE CODE)

  • TYPE (Type) — VARCHAR2(5) — 기본 키 — NOT NULL
  • TYPE_NAME (Type Name) — VARCHAR2(4000)
  • USE_YN (Use Yes Or No) — VARCHAR2(1)