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)