픽업패스

테이블 (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