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)