C2oor-admin

Tables (12)

Admins (관리자)

  • id — INT — Primary key — NOT NULL
  • admin_nickname — VARCHAR(20)
  • admin_password — VARCHAR(200)

Connect_statistics (접속통계)

  • id — INT — Primary key — NOT NULL
  • product_views_id — INT — Foreign key → product_views.id — NOT NULL
  • today_visit — INT

Main_views (메인화면)

  • id — INT — Primary key — NOT NULL
  • Product_management_id — INT — Foreign key → Product_managements.id — NOT NULL
  • Review_management_id — INT — Foreign key → Review_managements.id — NOT NULL
  • statistic_id — INT — Foreign key → Statistics.id — NOT NULL

Product_categorys (상품카테고리)

  • id — INT — Primary key — NOT NULL
  • product_category_name (product_category_naem) — VARCHAR(20)

Product_lists (상품목록)

  • id — INT — Primary key — NOT NULL
  • product_registration_id — INT — Foreign key → Product_registrations.id — NOT NULL

Product_managements (상품관리(카테고리))

  • id — INT — Primary key — NOT NULL
  • product_registration_id — INT — Foreign key → Product_registrations.id — NOT NULL
  • product_list_id — INT — Foreign key → Product_lists.id — NOT NULL

Product_options (상품옵션)

  • id — INT — Primary key — NOT NULL
  • product_option_size — VARCHAR(10)

Product_registrations (상품등록)

  • id — INT — Primary key — NOT NULL
  • product_category_id — INT — Foreign key → Product_categorys.id — NOT NULL
  • product_option_id — INT — Foreign key → Product_options.id — NOT NULL
  • product_name — VARCHAR(30)
  • product_text — VARCHAR(300)
  • product_price — INT
  • product_img_main — VARCHAR(300)
  • product_img_sub — VARCHAR(300)
  • product_count — INT

Review_managements (리뷰관리)

  • id — INT — Primary key — NOT NULL
  • 유저의게시물_id

Sales (매출)

  • id — INT — Primary key — NOT NULL
  • sales_day — VACHAR(20)
  • sales_number_order — INT
  • sales_product_purchase_amount — INT
  • sales_reserve — INT
  • sales_coupon — INT
  • sales_total_price — INT
  • slaes_net (sales_net) — INT

Statistics (통계)

  • id — INT — Primary key — NOT NULL
  • sales_id — INT — Foreign key → Sales.id — NOT NULL
  • connect_statistic_id — INT — Foreign key → Connect_statistics.id — NOT NULL

product_views (상품조회수)

  • id — INT — Primary key — NOT NULL
  • product_registration_id — INT — Foreign key → Product_registrations.id — NOT NULL