univHjp
Tables (8)
CopyOfunivUserInfo
- infoId — VARCHAR(255) — Primary key — NOT NULL
- univId — VARCHAR(255) — NOT NULL
- authId — VARCHAR(255) — NOT NULL — 담당 카테고리
- serviceYear — int
- servId — VARCHAR(255) — 개발자/운영자 아이디
- isServiced — VARCHAR(255)
Untitled
- Field — VARCHAR(255)
- Field3 — VARCHAR(255)
- infoId — VARCHAR(255) — NOT NULL
- univId — VARCHAR(255) — NOT NULL
authCat
- authId — VARCHAR(255) — Primary key — NOT NULL
- authName — nvarchar(20)
infoHistory
- historyId — VARCHAR(255) — Primary key — NOT NULL
- historyDate — dateTime
univ
- univId — VARCHAR(255) — Primary key — NOT NULL
- univCat — VARCHAR(255)
- region — nvarchar(50)
- univName — nvarchar(10)
- servId — VARCHAR(255) — 영업자 아이디
univUserInfo
- infoId — VARCHAR(255) — Primary key — NOT NULL
- authId — VARCHAR(255) — NOT NULL — 담당 카테고리
- servId — VARCHAR(255) — 개발자/운영자 아이디
univ_assign_list
- MAINCATEGORY — NN
- LOCATOINCATEGORY — NN
- UNIVNAME — NN
- SALESPERSON — VARCHAR(255)
- SERVICEYEAR — NN
- AOVERSEASKOREAN — VARCHAR(255)
- AEARLYACTION — NN
- AREGULARDICISION — NN
- APHARMACY — VARCHAR(255)
- AMDI — VARCHAR(255)
- AFOREIGNER — NN
- DOVERSEASKOREAN — VARCHAR(255)
- DEARLYACTION — NN
- DREGULARDICISION — NN
- DPHARMACY — VARCHAR(255)
- DMDI — VARCHAR(255)
- FACULTY — NN
- AGRADUATE — NN
- DGRADUATE — NN
user
- 유저PK (servId) — VARCHAR(60) — Primary key — NOT NULL
- 로그인아이디 (logId) — VARCHAR(60)
- 비밀번호 (pwd) — VARCHAR(60)
- 이름 (name) — VARCHAR(60)
- 직책 (rspofc) — VARCHAR(60)
- 직책코드 (rspofcCd) — VARCHAR(6)