픽업패스
테이블 (7)
APPLICATION (신청서)
- PK (APPLICATION_IDX) — INT — 기본 키 — NOT NULL
- FK (USER_IDX) — INT — 기본 키
- FK (HOSPITAL_IDX) — INT — 기본 키
- Field (AGREE) — CHAR(1)
- Field (PERIOD_START) — DATETIME
- Field (PERIOD_END) — DATETIME
- Field (METHOD) — VARCHAR
- Field (RECEIVER_NAME) — VARCHAR
- Field (RECEIVER_CODE) — VARCHAR
- Field (RECEIVER_AD) — VARCHAR
- Field2 (RECEIVER_AD_DETAIL) — VARCHAR
- Field (IDENTITY_IMG) — VARCHAR(URL)
- Field (APPLICATION_DATE) — DATETIME
APPLICATION_DETAILS (신청서상세(증명서포함))
- PK (DETAIL_IDX) — INT — 기본 키 — NOT NULL
- FK (APPLICATION_IDX) — INT — 기본 키
- FK (CERTIFICATE_IDX) — INT — 기본 키
CATEGORIES (증명서카테고리)
- PK (CATEGORY_IDX) — INT — 기본 키 — NOT NULL
- Field (CATEGORY_NAME) — VARCHAR
CERTIFICATES (증명서)
- PK (CERTIFICATE_IDX) — INT — 기본 키 — NOT NULL
- FK (CATEGORY_IDX) — INT — 기본 키
- Field (CERTIFICATE_NAME) — VARCHAR
HOSPITALS (병원)
- PK (HOSPITAL_IDX) — INT — 기본 키 — NOT NULL
- Field (HOSPITAL_NAME) — VARCHAR
- Field (HOSPITAL_TYPE) — VARCHAR
- Field (HOSPITAL_ADDRESS) — VARCHAR
- Field (QUESTION)
RECENT_SEARCH (최근 검색한 병원이름)
- PK (RECENT_IDX) — INT — 기본 키 — NOT NULL
- FK (USER_IDX) — INT — 기본 키
- FK (HOSPITAL_IDX) — INT — 기본 키
- Field (SEARCH_DATE) — DATETIME
USERS (유저)
- PK (USER_IDX) — INT — 기본 키 — NOT NULL
- Field (USER_ID) — VARCHAR
- Field (PASSWORD) — VARCHAR
- Field (NAME) — VARCHAR
- Field (PHONE) — VARCHAR