semi

Tables (11)

Untitled (member)

  • Key (email) — varchar2(50) — Primary key — NOT NULL
  • Field (pwd) — varchar2(20) — NOT NULL
  • Field (phone) — varchar(20)
  • Field (fname) — varchar2(20)
  • Field (lname) — varchar2(20)
  • Field (country) — varchar2(20)
  • Field (ip) — varchar2(20)
  • Field (p_country) — varchar2(40)
  • Field (myemail) — varchar2(50)

Untitled (reserve)

  • Key (no) — number — Primary key — NOT NULL
  • Field (price) — number — NOT NULL
  • Field (pnum) — number
  • Field (timestamp) — date
  • Key (email) — varchar2(50) — Foreign key → Untitled.Key — NOT NULL
  • Field (rpId) — number
  • Field (imp_uid) — varchar2(30)
  • Field2 (merchant_uid) — varchar2(30)
  • Key (pId) — number — Foreign key → Untitled.Key — NOT NULL

Untitled (product)

  • Key (pId) — number — Primary key — NOT NULL
  • Field (price) — number — NOT NULL
  • Field (count) — number
  • Field2 (options) — varchar2(100)
  • Key (title) — varchar2(100) — Foreign key → Untitled.Key — NOT NULL
  • Key (id) — varchar2(200) — Foreign key → Untitled.Key — NOT NULL

Untitled (admin)

  • Key (id) — varchar2(200) — Primary key — NOT NULL
  • Field (pwd) — varchar(20) — NOT NULL
  • Field (day) — varchar(30)
  • Field2 (name) — varchar(30)
  • Field (ip) — varchar2(20)

Untitled (country)

  • Key (city) — varchar2(20) — Primary key — NOT NULL
  • Field (country) — varchar2(100) — NOT NULL
  • Field (continent) — varchar2(20) — NOT NULL
  • Field (content) — varchar2(3000)
  • Field (lat) — number
  • Field2 (lon) — number
  • Field (time) — varchar2(100)
  • Field (money) — varchar2(100)
  • Field (month) — varchar2(200)
  • Field (imagepath) — varchar2(200)
  • Field (weather) — varchar2(200)

Untitled (review)

  • Key (no) — number — Primary key — NOT NULL
  • Field (timestamp) — date — NOT NULL
  • Field (content) — varchar2(500) — NOT NULL
  • Field (imagePath) — varchar2(100)
  • Field (star) — number
  • Key (email) — varchar2(50) — Foreign key → Untitled.Key — NOT NULL
  • Key (title) — varchar2(100) — Foreign key → Untitled.Key — NOT NULL

Untitled (notice)

  • Key (no) — number — Primary key — NOT NULL
  • Field (bId) — number — NOT NULL
  • Field (title) — varchar2(200) — NOT NULL
  • Field (content) — varchar2(4000) — NOT NULL
  • Key (id) — varchar2(200) — Foreign key → Untitled.Key — NOT NULL

Untitled (adminlog)

  • Key (no) — number — Primary key — NOT NULL
  • Field (time) — varchar2(30) — NOT NULL
  • Field (content) — varchar2(50)
  • Field (name) — varchar2(30)
  • Field (ip) — varchar2(20)
  • Key (id) — varchar2(200) — Foreign key → Untitled.Key — NOT NULL

Untitled (content)

  • Key (title) — varchar2(100) — Primary key — NOT NULL
  • Field (content) — clob
  • Field (imagePath) — varchar2(100)
  • Field (readcount) — number
  • Field2 (cId) — number
  • Key (city) — varchar2(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (id) — varchar2(200) — Foreign key → Untitled.Key — NOT NULL

Untitled (basket)

  • Key (no) — number — Primary key — NOT NULL
  • Field (day) — varchar2(100)
  • Field (price) — varch2(50)
  • Key (email) — varchar2(50) — Foreign key → Untitled.Key — NOT NULL
  • Key (pId) — number — Foreign key → Untitled.Key — NOT NULL

Untitled2 (question)

  • Key (no) — number — Primary key — NOT NULL
  • Field (title) — varchar2(20) — NOT NULL
  • Field (content) — varchar2(500) — NOT NULL
  • Field (comments) — varchar2(500)
  • Key (email) — varchar2(50) — Foreign key → Untitled.Key — NOT NULL
  • Field (qid) — number
  • Key (id) — varchar2(200) — Foreign key → Untitled.Key — NOT NULL