코배스

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