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