test
Tables (18)
address
- member_uid — number — NOT NULL
- address_name — varchar2(20) — NOT NULL
- address_recipient — varchar2(20) — NOT NULL
- address_info — varchar2(500) — NOT NULL
- address_detail — varchar2(300)
- address_post — varchar2(20) — NOT NULL
- address_hphone — varchar2(20)
- address_mphone — varchar2(20) — NOT NULL
board_notice
- member_uid — number — NOT NULL
- rdate — varchar2(20)
- YYYY-MM-DD — HH24:MI') — NOT NULL
- content — varchar2(2000) — NOT NULL
- deleted — char
board_photo
- product_id — number — NOT NULL
- photo_idx — number — NOT NULL
- category — varchar2(20) — NOT NULL
board_qna
- member_uid — number — NOT NULL
- product_id — number — NOT NULL
- option_id — number — NOT NULL
- rdate — varchar2(20)
- YYYY-MM-DD — HH24:MI') — NOT NULL
- content — varchar2(2000) — NOT NULL
- deleted — char
board_review
- member_uid — number — NOT NULL
- rdate — varchar2(20)
- YYYY-MM-DD — HH24:MI') — NOT NULL
- content — varchar2(2000) — NOT NULL
- deleted — char
- star — number — NOT NULL
- good — number — NOT NULL
login
- member_uid — number — NOT NULL
- member_id — varchar2(20) — NOT NULL
- member_pw — varchar2(20) — NOT NULL
member
- member_uid — number
- member_name — varchar2(100) — NOT NULL
- member_hphone — varchar2(20)
- member_mphone — varchar2(20) — NOT NULL
- member_email — varchar2(100) — NOT NULL
- member_post — varchar2(20) — NOT NULL
- member_address_info — varchar2(500) — NOT NULL
- member_address_detail — varchar2(300)
- member_rdate — varchar2(20)
- YYYY-MM-DD — HH24:MI') — NOT NULL
- member_deleted — char
member_coupon
- member_uid — number — NOT NULL
- option_id — number — NOT NULL
- coupon_sdate — varchar2(20)
- YYYY-MM-DD — HH24:MI') — NOT NULL
- coupon_edate — varchar2(20)
- YYYY-MM-DD — HH24:MI') — NOT NULL
member_detail
- member_uid — number — NOT NULL
- member_level — number
- member_address_default — varchar2(100)
- member_email_check — char
- member_raccount — varchar2(30)
- member_point — number
member_log
- log_id — number
- member_uid — number — NOT NULL
- option_id — number — NOT NULL
option_reg
- product_id — number — NOT NULL
- option_id — number — NOT NULL
order_log
- order_id — number
- member_uid — number
- order_recipient — varchar2(20) — NOT NULL
- order_address_info — varchar2(500) — NOT NULL
- order_address_detail — varchar2(300)
- order_post — varchar2(20) — NOT NULL
- order_hphone — varchar2(20)
- order_mphone — varchar2(20) — NOT NULL
- order_pay — varchar2(20) — NOT NULL
order_option
- order_id — number — NOT NULL
- log_id — number — NOT NULL
photo
- photo_idx — number
- photo_name — varchar2(100) — NOT NULL
- photo_path — varchar2(255) — NOT NULL
product
- product_id — number
- product_name — varchar2(20) — NOT NULL
- product_price — number — NOT NULL
- product_rdate — varchar2(20)
- YYYY-MM-DD — HH24:MI') — NOT NULL
product_option
- option_id — number
- option_category — varchar2(20) — NOT NULL
- option_name — varchar2(20) — NOT NULL
- option_value — varchar2(20) — NOT NULL
product_photo
- product_id — number — NOT NULL
- photo_idx — number — NOT NULL
- category — varchar2(20) — NOT NULL
product_reg
- product_id — number — NOT NULL
- product_count — number
- option_id — number — NOT NULL