종프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