슬개생
테이블 (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)