HOMEPLUS
Tables (21)
academies
- academy_code — VARCHAR(50)
- academy_name — VARCHAR(255)
area_city
- area_city_code — VARCHAR(50)
- area_city_name — VARCHAR(255)
board_comments
- board_comment_code — VARCHAR(50)
- board_detail_code — VARCHAR(50)
- board_comment_parent_code — VARCHAR(50)
- board_comment_level — INT
- board_comment_content — TEXT
- user_code — VARCHAR(50)
- board_comment_reg_date — DATE
- board_comment_del_yn — CHAR(1)
- board_comment_del_date — DATE
board_details
- board_detail_code — VARCHAR(50)
- board_detail_subject — VARCHAR(255)
- board_detail_content — TEXT
- user_code — VARCHAR(50)
- board_list_code — VARCHAR(50)
- board_detail_reg_date — DATE
- board_detail_modify_date — DATE
- board_detail_del_yn — CHAR(1)
- board_detail_del_date — DATE
board_images
- board_image_code — VARCHAR(50)
- board_image_name — VARCHAR(255)
- board_detail_code — VARCHAR(50)
- board_image_reg_date — DATE
board_lists
- board_list_code — VARCHAR(50)
- board_list_name — VARCHAR(255)
cart_lists
- cart_list_code — VARCHAR(50)
- products_detail_code — VARCHAR(50)
- cart_list_count — INT
- cart_list_reg_date — DATE
- user_code — VARCHAR(50)
- academy_code — VARCHAR(50)
cart_options
- cart_option_code — VARCHAR(50)
- cart_list_code — VARCHAR(50)
- product_options_group_name — VARCHAR(255)
- product_options_group_detail — VARCHAR(255)
- user_code — VARCHAR(50)
order_addr
- order_addr_code — VARCHAR(50)
- order_addr_name — VARCHAR(255)
- order_addr_prev — VARCHAR(255)
- order_addr_detail — VARCHAR(255)
- order_addr_default_yn — CHAR(1)
- order_addr_reg_date — DATE
- order_addr_setting — VARCHAR(255)
- order_addr_memo — TEXT
- order_addr_comm_yn — CHAR(1)
- order_addr_comm_pw — VARCHAR(255)
- area_city_code — VARCHAR(50)
- academy_code — VARCHAR(50)
order_details
- order_detail_code — VARCHAR(50)
- order_list_code — VARCHAR(50)
- products_detail_code — VARCHAR(50)
- order_detail_count — INT
order_lists
- order_list_code — VARCHAR(50)
- user_code — VARCHAR(50)
- order_list_date — DATE
- order_addr_code — VARCHAR(50)
- order_list_name — VARCHAR(255)
- order_list_tel — VARCHAR(50)
- order_list_payment — VARCHAR(50)
- academy_code — VARCHAR(50)
order_tracking
- order_tracking_code — VARCHAR(50)
- user_code — VARCHAR(50)
- order_tracking_company_name — VARCHAR(255)
- order_tracking_deli_code — VARCHAR(255)
- order_tracking_reg_date — DATE
- order_list_code — VARCHAR(50)
- order_tracking_status — VARCHAR(50)
- order_tracking_start_date — DATE
- order_tracking_done_date — DATE
- order_tracking_confirm_date — DATE
- academy_code — VARCHAR(50)
product_options
- product_options_code — VARCHAR(50)
- product_options_group_name — VARCHAR(255)
- product_options_group_detail — VARCHAR(255)
- products_detail_code — VARCHAR(50)
- product_options_reg_date — DATE
product_types
- product_type_code — VARCHAR(50)
- product_type_name — VARCHAR(255)
- products_detail_code — VARCHAR(50)
- product_type_reg_date — DATE
products_details
- products_detail_code — VARCHAR(50)
- products_detail_name — VARCHAR(255)
- sub_sub_cat_nm — VARCHAR(50)
- products_detail_grade — INT
- user_code — VARCHAR(50)
- products_detail_publisher — VARCHAR(255)
- products_detail_author — VARCHAR(255)
- products_detail_page — INT
- products_detail_spec — VARCHAR(255)
- products_detail_price — INT
- products_detail_discount_rate — FLOAT
- products_detail_ship_yn — CHAR(1)
- products_detail_reg_date — DATE
- products_detail_publish_date — DATE
- products_detail_del_yn — CHAR(1)
- products_detail_del_date — DATE
- products_detail_status — VARCHAR(50)
- products_detail_content1 — TEXT
- products_detail_content2 — TEXT
- academy_code — VARCHAR(50)
products_images
- products_images_code — VARCHAR(50)
- products_images_name — VARCHAR(255)
- products_detail_code — VARCHAR(50)
- products_images_category — VARCHAR(50)
- products_images_reg_date — DATE
stock_controls
- stock_control_code — VARCHAR(50)
- products_detail_code — VARCHAR(50)
- stock_control_count — INT
- stock_control_reg_date — DATETIME
- stock_control_storage_loc — VARCHAR(255)
- academy_code — VARCHAR(50)
stock_logs
- stock_log_code — VARCHAR(50)
- stock_control_code — VARCHAR(50)
- stock_log_count — INT
- stock_log_reg_date — DATETIME
stock_losses
- stock_loss_code — VARCHAR(50)
- stock_control_code — VARCHAR(50)
- stock_loss_count — INT
- stock_loss_reg_date — DATETIME
- stock_loss_reason — VARCHAR(255)
sub_sub_categories
- sub_sub_cat_nm — VARCHAR(50)
- sub_sub_cat_name — VARCHAR(255)
users
- user_code — VARCHAR(50)
- user_name — VARCHAR(255)