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