TestTable

Tables (3)

Untitled (TEST_COVID)

  • Key (COVID_NO) — NUMBER — Primary key — NOT NULL
  • Field (COVID_DCIDECNT) — NUMBER
  • Field (COVID_DEATHCNT) — NUMBER
  • Field (COVID_DATE) — SYSDATE

Untitled (TEST_USER_INFO)

  • Key (USER_NO) — NUMBER — Primary key — NOT NULL
  • Field (USER_ID) — VARCHAR2(20)
  • Field2 (USER_PW) — VARCHAR2(200)
  • Field (USER_SALT) — VARCHAR2(200)
  • Field (USER_YOUTUBE) — VARCHAR2(1)
  • Field (USER_COVID) — VARCHAR2(1)
  • Field (USER_FAVORITES) — VARCHAR2(1)
  • Field (USER_IMAGE) — VARCHAR2(250)
  • Field (USER_REG_DATE) — SYSDATE
  • Field (USER_DELETEYN) — VARCHAR2(1)

Untitled (TEST_FAVORITES)

  • Key (FAVORITES_NO) — NUMBER — Primary key — NOT NULL
  • Field (USER_NO) — NUMBER — NOT NULL
  • Field (FAVORITES_URL) — VARCHAR2(250)
  • Field (FAVORITES_NAME) — VARCHAR2(40)
  • Field (FAVORITES_REG_DATE) — SYSDATE
  • Field (FAVORITES_UPD_DATE) — SYSDATE
  • Field (FAVORITES_DELETEYN) — VARCHAR2(1)