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