ㅁㅇㄴㄹ

Tables (13)

bk_cate

  • cate_id — number — Primary key — NOT NULL
  • cate — varchar2(50)

book

  • bk_id — varchar2(50) — Primary key — NOT NULL
  • cate_id — number — NOT NULL
  • bk_name — varchar2(50) — NOT NULL
  • bk_price — number — NOT NULL
  • bk_quantity — number — NOT NULL
  • bk_author — varchar2(50)
  • bk_pub — varchar2(50)
  • bk_published — varchar2(50) — NOT NULL

cart

  • cart_id — number — Primary key — NOT NULL
  • u_id — varchar2(50) — NOT NULL

cart_item

  • cart_item_id — number — Primary key — NOT NULL
  • cart_id — number — NOT NULL
  • pro_id — varchar2(50) — NOT NULL
  • quantity — number — NOT NULL

membership

  • grade — varchar2(50) — Primary key — NOT NULL
  • mem_disc — varchar2(10)
  • u_id — varchar2(50) — NOT NULL

order_item

  • order_item_id — number — Primary key — NOT NULL
  • order_id — number — NOT NULL
  • cart_item_id — number — NOT NULL
  • quantity — number — NOT NULL

order_table

  • order_id — number — Primary key — NOT NULL
  • u_id — varchar2(50) — NOT NULL
  • order_status — varchar2(50) — NOT NULL
  • total_amount — number — NOT NULL

product

  • pro_id — varchar2(50) — Primary key — NOT NULL
  • pro_grade — varchar2(50)
  • bk_id — varchar2(50)
  • re_num — number
  • sup_id — varchar2(50)

review

  • re_num — number — Primary key — NOT NULL
  • u_id — varchar2(50) — NOT NULL
  • re_title — varchar2(50)
  • re_body — varchar2(255)
  • re_grade — number(5)
  • re_date — date

review_comment

  • cmt_id — varchar2(50) — Primary key — NOT NULL
  • u_id — varchar2(50) — NOT NULL
  • re_num — number — NOT NULL
  • cmt_body — varchar2(255)
  • cmt_date — date

sup_cate

  • cate_id — number — Primary key — NOT NULL
  • cate — varchar2(50)

supplies

  • sup_id — varchar2(50) — Primary key — NOT NULL
  • cate_id — number — NOT NULL
  • Field — varchar2(50)
  • Field4 — number
  • Field2 — varchar2(50)
  • Field3 — varchar2(50)

user_info

  • u_id — varchar2(50) — Primary key — NOT NULL
  • u_name — varchar2(50)
  • u_login — varchar2(50)
  • u_pw — varchar2(50)
  • u_mail — varchar2(50)
  • u_addr — varchar2(255)