TRAVEL

Tables (3)

Copy Of Untitled (TRAVEL_REPLY)

  • PK (IDX) — NUMBER — Primary key — NOT NULL
  • Field2 (USER_ID) — VARCHAR2(100)
  • Field (STORY_IDX) — NUMBER
  • Field3 (REPLY) — VARCHAR2(2000)
  • Field4 (WDATE) — DATE
  • Key (IDX2) — NUMBER — Foreign key → Untitled2.Key — NOT NULL
  • PK (USER_NUM) — NUMBER — Foreign key → Untitled.PK — NOT NULL

Untitled (TRAVEL_USER)

  • PK (USER_NUM) — NUMBER — Primary key — NOT NULL
  • Field2 (USER_ID) — VARCHAR2(100)
  • Field (USER_NAME) — VARCHAR2(100)
  • Field3 (USER_PWD) — VARCHAR2(100)
  • Field4 (USER_EMAIL) — VARCHAR2(300)

Untitled2 (TRAVEL_STORY)

  • Key (IDX) — NUMBER — Primary key — NOT NULL
  • Field — VARCHAR2(100)
  • Field2 (TITLE) — VARCHAR2(500)
  • Field3 (STORY) — VARCHAR2(4000)
  • Field4 (WDATE) — DATE
  • Field2 (READNUM) — NUMBER
  • Field3 (FILENAME) — VARCHAR2(200)
  • Field2 (FILESIZE) — LONG
  • PK (USER_NUM) — NUMBER — Foreign key → Untitled.PK — NOT NULL