테스트
테이블 (9)
checkes
- mykey — varchar2(255)
- myvalue — varchar2(255)
- module — varchar2(255)
- field — varchar2(255)
- kind — varchar2(255)
members
- mid — varchar2(50)
- password — varchar2(50) — NOT NULL
- name — varchar2(30) — NOT NULL
- email — varchar2(50) — NOT NULL
- phone — varchar2(50) — NOT NULL
- address1 — varchar2(100) — NOT NULL
- address2 — varchar2(100) — NOT NULL
- gender — varchar2(50) — NOT NULL
- birth — varchar2(30) — NOT NULL
- mpoint — number
- createdate — date
orderdetails
- odid — number — NOT NULL
- oid — number
- pno — number
- qty — int — NOT NULL
- price — int — NOT NULL
orders
- oid — number
- mid — varchar2(50)
- orderdate — date
productreviews
- bno — number
- mid — varchar2(50) — NOT NULL
- btitle — varchar2(100) — NOT NULL
- bwriter — varchar2(50) — NOT NULL
- bcontent — varchar2(2048) — NOT NULL
- bimg — varchar2(500) — NOT NULL
- breview — number
- bregdate — date
products
- pno — int
- productname — varchar2(50) — NOT NULL
- productcode — number — NOT NULL
- price — int — NOT NULL
- pqty — int — NOT NULL
- pcontent — varchar2(255) — NOT NULL
- category — varchar2(50) — NOT NULL
- pimg — varchar2(300) — NOT NULL
senterboards
- sno — number
- stitle — varchar2(255) — NOT NULL
- swriter — varchar2(50) — NOT NULL
- scontent — varchar2(2048) — NOT NULL
- swritedate — date
- simg — varchar2(300) — NOT NULL
service
- sno — number — NOT NULL
- swriter — varchar2(100) — NOT NULL
- title — varchar2(100) — NOT NULL
- content — varchar2(2000) — NOT NULL
- writedate — DATE — NOT NULL
- image — varchar2(1000)
shoppinginfo
- mid — varchar2(50)
- productcode — number — NOT NULL
- qty — int — NOT NULL
- price — int — NOT NULL
- discount — int — NOT NULL
- pimg — varchar2(300) — NOT NULL