종프1

테이블 (12)

Category (Untitled4)

  • categoryId (Key) — String — 기본 키 — NOT NULL
  • name (Field) — String

Context (Untitled6)

  • contextId (Key) — String — 기본 키 — NOT NULL
  • context (Field) — String
  • convesationId (Key2) — String — 외래 키 → Conversation.convesationId — NOT NULL

Conversation (Untitled5)

  • convesationId (Key) — String — 기본 키 — NOT NULL
  • Date (Field) — String
  • responseRatio (Field2) — float
  • SeniorUserId (Key2) — String — 외래 키 → Senior User.SeniorUserId — NOT NULL

Location (Untitled)

  • locationId (Key) — String — 기본 키 — NOT NULL
  • loginId (Field2) — String
  • location (Field) — String
  • locationApiId (Key3) — String — 외래 키 → Location Api.locationApiId — NOT NULL

Location Api (Untitled7)

  • locationApiId (Key) — String — 기본 키 — NOT NULL
  • ConfmKey (Field) — String
  • returnUrl (Field2) — String
  • resultType (Field3) — String
  • useDetailAddr (Field4) — String

MatchProgram (Untitled12)

  • matchProgramId (Key) — String — 기본 키 — NOT NULL
  • location (Field) — String
  • programName (Field2) — String
  • regionalProgramId (Key2) — String — 외래 키 → Regional Program.regionalProgramId — NOT NULL
  • locationId (Key3) — String — 외래 키 → Location.locationId — NOT NULL

Preferred Category (Untitled9)

  • PreferredCategoryId (Key3) — String — 기본 키 — NOT NULL
  • categoryId (Key) — String — 외래 키 → Category.categoryId — NOT NULL
  • SeniorUserId (Key2) — String — 외래 키 → Senior User.SeniorUserId — NOT NULL
  • regionalProgramId (Key4) — String — 외래 키 → Regional Program.regionalProgramId — NOT NULL
  • loginId (Field) — String
  • categoryName (Field2) — String
  • programName (Field3) — String

Question (Untitled8)

  • questionId (Key) — String — 기본 키 — NOT NULL
  • hour (Field4) — int
  • startTime (Field) — float
  • endTime (Field2) — float
  • responseTime (Field3) — float
  • convesationId (Key2) — String — 외래 키 → Conversation.convesationId — NOT NULL

Regional Program (Untitled10)

  • regionalProgramId (Key) — String — 기본 키 — NOT NULL
  • programName (Field) — String
  • dateProvided (Field2) — String
  • programInfo (Field3) — String

Senior User (Untitled2)

  • SeniorUserId (Key) — String — 기본 키 — NOT NULL
  • loginId (Field5) — String
  • name (Field2) — String
  • password (Field) — String
  • phoneNumber (Field4) — String
  • supervisorCodeId (Key2) — String — 외래 키 → Supervisor Code.supervisorCodeId — NOT NULL
  • locationId (Key3) — String — 외래 키 → Location.locationId — NOT NULL

Superviosr User (Untitled3)

  • SupervisorUserKey (Key) — String — 기본 키 — NOT NULL
  • loginId (Field) — String
  • name (Field2) — String
  • password (Field3) — String
  • phoneNumber (Field4) — String
  • supervisorCodeId (Key2) — String — 외래 키 → Supervisor Code.supervisorCodeId — NOT NULL

Supervisor Code (Untitled11)

  • supervisorCodeId (Key) — String — 기본 키 — NOT NULL
  • code (Field) — String