test

Tables (20)

admin

  • admin_code — INT
  • admin_name — VARCHAR(100) — NOT NULL
  • admin_id — VARCHAR(100) — NOT NULL
  • admin_pwd — VARCHAR(100) — NOT NULL
  • admin_enroll_date — DATETIME
  • admin_update_date — DATETIME
  • admin_delete_date — DATETIME
  • admin_email — VARCHAR(50) — NOT NULL
  • admin_phone — VARCHAR(50) — NOT NULL
  • admin_access_number — VARCHAR(255) — NOT NULL
  • admin_role — VARCHAR(45) — NOT NULL
  • admin_status — INT — NOT NULL
  • admin_pwd_check — INT — NOT NULL

ask

  • ask_code — INT
  • ask_title — VARCHAR(255)
  • ask_content — VARCHAR(255) — NOT NULL
  • ask_status — ENUM('답변대기', '답변완료') — NOT NULL
  • ask_answer — VARCHAR(255)
  • ask_enroll_date — DATETIME — NOT NULL
  • ask_update_date — DATETIME
  • ask_comment_date — DATETIME
  • franchise_owner_code — INT — NOT NULL
  • admin_code — INT — NOT NULL

category_first

  • category_first_code — INT
  • category_first_name — VARCHAR(255) — NOT NULL
  • category_first_enroll_date — DATETIME — NOT NULL
  • category_first_update_date — DATETIME

category_second

  • category_second_code — INT
  • category_second_name — VARCHAR(255) — NOT NULL
  • category_first_code — INT — NOT NULL
  • category_second_enroll_date — DATETIME — NOT NULL
  • category_second_update_date — DATETIME

category_third

  • category_third_code — INT
  • category_third_name — VARCHAR(255) — NOT NULL
  • category_second_code — INT — NOT NULL
  • category_third_enroll_date — DATETIME — NOT NULL
  • category_third_update_date — DATETIME
  • category_third_delete_date — DATETIME

company

  • company_code — INT
  • company_name — VARCHAR(255) — NOT NULL
  • company_call — VARCHAR(255) — NOT NULL
  • company_email — VARCHAR(255) — NOT NULL
  • company_business_num — VARCHAR(255) — NOT NULL
  • company_address — VARCHAR(255) — NOT NULL
  • company_ceo — VARCHAR(255) — NOT NULL
  • company_fax — VARCHAR(255) — NOT NULL

delivery_man

  • delivery_man_code — INT
  • delivery_man_name — VARCHAR(255) — NOT NULL
  • delivery_man_id — VARCHAR(255) — NOT NULL
  • delivery_man_pwd — VARCHAR(255) — NOT NULL
  • delivery_man_phone — VARCHAR(255) — NOT NULL
  • delivery_man_enroll_date — DATETIME — NOT NULL
  • delivery_man_update_date — DATETIME — NOT NULL
  • delivery_man_delete_date — DATETIME
  • delivery_man_role — VARCHAR(45) — NOT NULL
  • delivery_man_pwd_check — INT — NOT NULL
  • delivery_man_status — INT — NOT NULL

exchange

  • exchange_code — INT
  • exchange_date — DATETIME — NOT NULL
  • exchange_status — ENUM('반송신청', '반송중', '처리대기', '처리완료', '반환대기', '반환중', '반환완료') — NOT NULL
  • franchise_code — INT — NOT NULL

exchange_product

  • exchange_product_code — INT
  • exchange_product_status — ENUM('교환', '폐기') — NOT NULL
  • exchange_product_count — INT — NOT NULL
  • exchange_product_dis_count — INT
  • exchange_product_normal_count — INT
  • product_code — INT — NOT NULL
  • exchange_code — INT — NOT NULL

franchise

  • franchise_code — INT
  • franchise_name — VARCHAR(255)
  • franchise_address — VARCHAR(255)
  • franchise_call — VARCHAR(255)
  • franchise_enroll_date — DATETIME — NOT NULL
  • franchise_update_date — DATETIME
  • franchise_delete_date — DATETIME
  • franchise_business_num — VARCHAR(255)
  • franchise_delivery_date — ENUM('월_목', '화_금', '수_금')
  • franchise_owner_code — INT
  • admin_code — INT
  • delivery_man_code — INT

franchise_owner

  • franchise_owner_code — INT
  • franchise_owner_name — VARCHAR(255) — NOT NULL
  • franchise_owner_id — VARCHAR(255) — NOT NULL
  • franchise_owner_pwd — VARCHAR(255) — NOT NULL
  • franchise_owner_email — VARCHAR(255) — NOT NULL
  • franchise_owner_phone — VARCHAR(255) — NOT NULL
  • franchise_owner_enroll_date — DATETIME — NOT NULL
  • franchise_owner_update_date — DATETIME — NOT NULL
  • franchise_owner_delete_date — DATETIME
  • franchise_owner_role — VARCHAR(45) — NOT NULL
  • franchise_owner_pwd_check — INT — NOT NULL
  • franchise_owner_status — INT — NOT NULL

franchise_warehouse

  • franchise_warehouse_code — INT
  • franchise_warehouse_total — INT — NOT NULL
  • franchise_warehouse_count — INT — NOT NULL
  • franchise_warehouse_enable — INT — NOT NULL
  • franchise_warehouse_favorite — INT
  • franchise_code — INT — NOT NULL
  • product_code — INT — NOT NULL

invoice

  • invoice_code — INT
  • delivery_status — ENUM('배송전', '배송중', '배송완료') — NOT NULL
  • delivery_date — DATETIME — NOT NULL
  • request_code — INT — NOT NULL

log

  • log_code — INT
  • log_changer — VARCHAR(255) — NOT NULL
  • log_date — DATETIME — NOT NULL
  • log_status — ENUM('등록', '수정', '삭제') — NOT NULL
  • log_content — VARCHAR(255) — NOT NULL
  • log_target — VARCHAR(255) — NOT NULL

notice

  • notice_code — INT
  • notice_title — VARCHAR(255) — NOT NULL
  • notice_enroll_date — DATETIME — NOT NULL
  • notice_content — VARCHAR(255) — NOT NULL
  • notice_update_date — DATETIME
  • admin_code — INT — NOT NULL

product

  • product_code — INT
  • product_name — VARCHAR(255) — NOT NULL
  • product_price — INT — NOT NULL
  • product_enroll_date — DATETIME — NOT NULL
  • product_update_date — DATETIME
  • product_content — VARCHAR(255) — NOT NULL
  • product_color — ENUM('빨간색', '주황색', '노란색', '초록색', '파란색', '남색', '보라색') — NOT NULL
  • product_size — INT — NOT NULL
  • product_gender — ENUM('남성의류', '여성의류')
  • product_total_count — INT — NOT NULL
  • product_status — ENUM('공급가능', '일시제한', '단종', '품절') — NOT NULL
  • product_exposure_status — INT — NOT NULL
  • product_notice_count — INT — NOT NULL
  • category_third_code — INT — NOT NULL
  • product_dis_count — INT
  • product_count — INT — NOT NULL

product_image

  • product_image_code — INT
  • url — VARCHAR(255) — NOT NULL
  • product_code — INT — NOT NULL

request

  • request_code — INT
  • request_date — DATETIME — NOT NULL
  • request_total_price — INT — NOT NULL
  • request_condition — ENUM('승인대기', '승인완료', '승인거부', '배송중', '검수대기', '검수완료') — NOT NULL
  • request_reason — VARCHAR(255)
  • franchise_code — INT — NOT NULL
  • exchange_code — INT

request_product

  • request_product_code — INT
  • request_product_count — INT — NOT NULL
  • request_product_get_count — INT
  • request_code — INT — NOT NULL
  • product_code — INT — NOT NULL

specs

  • specs_code — INT
  • specs_date — DATETIME — NOT NULL
  • request_code — INT — NOT NULL