코배스
테이블 (6)
Products (SERVICE)
- ServiceCode (Service_Code) — NOT NULL — 외래 키 → Service_Code.ServiceCode — NOT NULL
- Field
Service_02 (CopyOfSERVICE)
- ServiceId (SERVICE_CODE) — NOT NULL — 기본 키 — NOT NULL
- Field
Service_03 (CopyOfCopyOfSERVICE)
- ServiceId (SERVICE_CODE) — NOT NULL — 기본 키 — NOT NULL
- Field
Service_Code (Untitled)
- ServiceCode (Service_Code) — NOT NULL — 기본 키 — NOT NULL
Subcription (SBUCRIPTION)
- UserId (USR_ID) — NOT NULL — 외래 키 → User.UserId — NOT NULL
- ServiceCode (Service_Code) — NOT NULL — 외래 키 → Service_Code.ServiceCode — NOT NULL
- RegDate (SUBSCRIPTION_REGDATE) — NOT NULL
- ExDate (SUBSCRIPTION_EXDATE) — NOT NULL
- ServiceId (SERVICE_CODE) — NOT NULL — NOT NULL
User (USER)
- UserId (USR_ID) — NOT NULL — 기본 키 — NOT NULL
- password (USR_PWD) — NOT NULL
- UserName (USR_NM) — NOT NULL