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