QR

Tables (3)

QR (Untitled2)

  • SERVICE (Service) — VARCHAR(10) — Primary key — NOT NULL
  • IDX (Idx) — INT — Primary key — NOT NULL
  • URL (Url) — VARCHAR(200) — NOT NULL
  • REGISTER (Register) — VARCHAR(10) — NOT NULL
  • REGDATE (RegDate) — VARCHAR(20)
  • ENDDATE (EndDate) — VARCHAR(20)

QR_LINKINFO (QR)

  • IDX (Idx) — INT — Primary key — NOT NULL
  • SERVICE (Service) — VARCHAR(10) — Primary key
  • SERVICEIDX (ServiceIdx) — VARCHAR(10) — Primary key
  • URL (Url) — VARCHAR(200) — NOT NULL
  • REGIST_USERID (Regist_Userid) — VARCHAR2(30) — NOT NULL
  • REGDATE (RegDate) — DATE
  • EDIT_USERID (Update_Userid) — VARCHAR2(30)
  • EDITDATE (Update) — DATE
  • ENDDATE (EndDate) — DATE

QR_LINKINFO (CopyOfQR)

  • SERVICE (Service) — VARCHAR(10) — Primary key
  • SERVICEIDX (ServiceIdx) — VARCHAR(10) — Primary key
  • URL (Url) — VARCHAR(200) — NOT NULL
  • REGIST_USERID (Regist_Userid) — VARCHAR2(30) — NOT NULL
  • REGDATE (RegDate) — VARCHAR(20)
  • EDIT_USERID (Update_Userid) — VARCHAR2(30)
  • EDITDATE (Update) — VARCHAR(20)
  • ENDDATE (EndDate) — VARCHAR(20)