=== accounts_user ===
CREATE TABLE "accounts_user" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "password" varchar(128) NOT NULL, "last_login" datetime NULL, "is_superuser" bool NOT NULL, "username" varchar(150) NOT NULL UNIQUE, "first_name" varchar(150) NOT NULL, "last_name" varchar(150) NOT NULL, "email" varchar(254) NOT NULL, "is_staff" bool NOT NULL, "is_active" bool NOT NULL, "date_joined" datetime NOT NULL, "role" varchar(20) NOT NULL, "phone" varchar(20) NOT NULL, "avatar" varchar(100) NULL, remember_token varchar(100) NULL, email_verified_at datetime NULL)

=== accounts_user_groups ===
CREATE TABLE "accounts_user_groups" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "user_id" bigint NOT NULL REFERENCES "accounts_user" ("id") DEFERRABLE INITIALLY DEFERRED, "group_id" integer NOT NULL REFERENCES "auth_group" ("id") DEFERRABLE INITIALLY DEFERRED)

=== accounts_user_user_permissions ===
CREATE TABLE "accounts_user_user_permissions" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "user_id" bigint NOT NULL REFERENCES "accounts_user" ("id") DEFERRABLE INITIALLY DEFERRED, "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id") DEFERRABLE INITIALLY DEFERRED)

=== auth_group ===
CREATE TABLE "auth_group" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(150) NOT NULL UNIQUE)

=== auth_group_permissions ===
CREATE TABLE "auth_group_permissions" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "group_id" integer NOT NULL REFERENCES "auth_group" ("id") DEFERRABLE INITIALLY DEFERRED, "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id") DEFERRABLE INITIALLY DEFERRED)

=== auth_permission ===
CREATE TABLE "auth_permission" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "content_type_id" integer NOT NULL REFERENCES "django_content_type" ("id") DEFERRABLE INITIALLY DEFERRED, "codename" varchar(100) NOT NULL, "name" varchar(255) NOT NULL)

=== contacts_contact ===
CREATE TABLE "contacts_contact" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "full_name" varchar(255) NOT NULL, "email" varchar(254) NOT NULL, "phone" varchar(20) NOT NULL, "subject" varchar(20) NOT NULL, "content" text NOT NULL, "is_resolved" bool NOT NULL, "created_at" datetime NOT NULL)

=== core_aboutcompany ===
CREATE TABLE "core_aboutcompany" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "history" text NOT NULL, "vision" text NOT NULL, "mission" text NOT NULL, "video_url" varchar(200) NOT NULL, "factory_title" varchar(150) NOT NULL, "factory_description" text NOT NULL, "section_description" text NOT NULL, "section_subtitle" varchar(100) NOT NULL, "section_title" varchar(200) NOT NULL, "video_overlay_subtitle" varchar(200) NOT NULL, "video_overlay_title" varchar(150) NOT NULL, "video_section_description" text NOT NULL, "video_section_subtitle" varchar(100) NOT NULL, "video_section_title" varchar(200) NOT NULL, "open_letter" text NOT NULL, "history_title" varchar(200) NOT NULL, "badge_icon" varchar(10) NOT NULL, "badge_subtitle" varchar(100) NOT NULL, "badge_title" varchar(50) NOT NULL, "factory_icon" varchar(10) NOT NULL)

=== core_banner ===
CREATE TABLE "core_banner" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "title" varchar(200) NOT NULL, "subtitle" varchar(200) NOT NULL, "description" text NOT NULL, "image" varchar(100) NOT NULL, "cta_text" varchar(50) NOT NULL, "cta_link" varchar(200) NOT NULL, "order" integer unsigned NOT NULL CHECK ("order" >= 0), "is_active" bool NOT NULL)

=== core_branch ===
CREATE TABLE "core_branch" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(200) NOT NULL, "branch_type" varchar(50) NOT NULL, "address" varchar(300) NOT NULL, "phone" varchar(50) NOT NULL, "order" integer unsigned NOT NULL CHECK ("order" >= 0))

=== core_corevalue ===
CREATE TABLE "core_corevalue" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "title" varchar(100) NOT NULL, "description" text NOT NULL, "icon" varchar(50) NOT NULL, "order" integer unsigned NOT NULL CHECK ("order" >= 0), "about_id" bigint NOT NULL REFERENCES "core_aboutcompany" ("id") DEFERRABLE INITIALLY DEFERRED)

=== core_factoryimage ===
CREATE TABLE "core_factoryimage" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "image" varchar(100) NOT NULL, "order" integer unsigned NOT NULL CHECK ("order" >= 0), "about_id" bigint NOT NULL REFERENCES "core_aboutcompany" ("id") DEFERRABLE INITIALLY DEFERRED)

=== core_sitesetting ===
CREATE TABLE "core_sitesetting" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "address" varchar(255) NOT NULL, "phone" varchar(20) NOT NULL, "hotline" varchar(20) NOT NULL, "email" varchar(254) NOT NULL, "working_hours" varchar(150) NOT NULL, "map_embed_url" varchar(500) NOT NULL, "facebook" varchar(200) NOT NULL, "zalo" varchar(200) NOT NULL, "youtube" varchar(200) NOT NULL, "tiktok" varchar(200) NOT NULL, "copyright" varchar(255) NOT NULL, "favicon" varchar(100) NULL, "keywords" varchar(500) NOT NULL, "logo" varchar(100) NULL, "logo_footer" varchar(100) NULL, "meta_description" text NOT NULL, "meta_title" varchar(255) NOT NULL, "site_name" varchar(100) NOT NULL, "tagline" varchar(200) NOT NULL)

=== django_admin_log ===
CREATE TABLE "django_admin_log" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "object_id" text NULL, "object_repr" varchar(200) NOT NULL, "action_flag" smallint unsigned NOT NULL CHECK ("action_flag" >= 0), "change_message" text NOT NULL, "content_type_id" integer NULL REFERENCES "django_content_type" ("id") DEFERRABLE INITIALLY DEFERRED, "user_id" bigint NOT NULL REFERENCES "accounts_user" ("id") DEFERRABLE INITIALLY DEFERRED, "action_time" datetime NOT NULL)

=== django_content_type ===
CREATE TABLE "django_content_type" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "app_label" varchar(100) NOT NULL, "model" varchar(100) NOT NULL)

=== django_migrations ===
CREATE TABLE "django_migrations" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "app" varchar(255) NOT NULL, "name" varchar(255) NOT NULL, "applied" datetime NOT NULL)

=== django_session ===
CREATE TABLE "django_session" ("session_key" varchar(40) NOT NULL PRIMARY KEY, "session_data" text NOT NULL, "expire_date" datetime NOT NULL)

=== news_article ===
CREATE TABLE "news_article" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "title" varchar(255) NOT NULL, "slug" varchar(255) NOT NULL UNIQUE, "excerpt" text NOT NULL, "thumbnail" varchar(100) NULL, "author" varchar(100) NOT NULL, "view_count" integer unsigned NOT NULL CHECK ("view_count" >= 0), "tags" varchar(255) NOT NULL, "meta_title" varchar(255) NOT NULL, "meta_description" text NOT NULL, "is_active" bool NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "category_id" bigint NOT NULL REFERENCES "news_newscategory" ("id") DEFERRABLE INITIALLY DEFERRED, "content" text NOT NULL)

=== news_newscategory ===
CREATE TABLE "news_newscategory" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(100) NOT NULL, "slug" varchar(120) NOT NULL UNIQUE, "order" integer unsigned NOT NULL CHECK ("order" >= 0))

=== partners_certification ===
CREATE TABLE "partners_certification" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "title" varchar(255) NOT NULL, "year" integer unsigned NOT NULL CHECK ("year" >= 0), "image" varchar(100) NULL, "order" integer unsigned NOT NULL CHECK ("order" >= 0), "is_active" bool NOT NULL)

=== partners_client ===
CREATE TABLE "partners_client" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(150) NOT NULL, "logo" varchar(100) NULL, "order" integer unsigned NOT NULL CHECK ("order" >= 0), "is_active" bool NOT NULL)

=== partners_partner ===
CREATE TABLE "partners_partner" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(150) NOT NULL, "website" varchar(200) NOT NULL, "logo" varchar(100) NULL, "order" integer unsigned NOT NULL CHECK ("order" >= 0), "is_active" bool NOT NULL)

=== products_category ===
CREATE TABLE "products_category" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(100) NOT NULL, "slug" varchar(120) NOT NULL UNIQUE, "icon" varchar(50) NOT NULL, "order" integer unsigned NOT NULL CHECK ("order" >= 0), "color" varchar(20) NOT NULL, "icon_class" varchar(100) NOT NULL, "parent_id" bigint NULL REFERENCES "products_category" ("id") DEFERRABLE INITIALLY DEFERRED)

=== products_product ===
CREATE TABLE "products_product" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(255) NOT NULL, "slug" varchar(255) NOT NULL UNIQUE, "thumbnail" varchar(100) NULL, "short_description" text NOT NULL, "description" text NOT NULL, "ingredients" text NOT NULL, "usage" text NOT NULL, "dosage" text NOT NULL, "contraindications" text NOT NULL, "side_effects" text NOT NULL, "storage" text NOT NULL, "registration_number" varchar(100) NOT NULL, "manufacturer" varchar(255) NOT NULL, "rating" decimal NOT NULL, "review_count" integer unsigned NOT NULL CHECK ("review_count" >= 0), "is_new" bool NOT NULL, "is_featured" bool NOT NULL, "pdf_file" varchar(100) NULL, "pdf_url" varchar(200) NOT NULL, "video_url" varchar(200) NOT NULL, "is_active" bool NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "category_id" bigint NOT NULL REFERENCES "products_category" ("id") DEFERRABLE INITIALLY DEFERRED, "availability_status" varchar(50) NOT NULL, "distributor" varchar(255) NULL)

=== products_productimage ===
CREATE TABLE "products_productimage" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "image" varchar(100) NOT NULL, "order" integer unsigned NOT NULL CHECK ("order" >= 0), "product_id" bigint NOT NULL REFERENCES "products_product" ("id") DEFERRABLE INITIALLY DEFERRED)

=== recruitment_application ===
CREATE TABLE "recruitment_application" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "full_name" varchar(255) NOT NULL, "email" varchar(254) NOT NULL, "phone" varchar(20) NOT NULL, "cv_file" varchar(100) NOT NULL, "cover_letter" text NOT NULL, "created_at" datetime NOT NULL, "job_id" bigint NOT NULL REFERENCES "recruitment_job" ("id") DEFERRABLE INITIALLY DEFERRED)

=== recruitment_job ===
CREATE TABLE "recruitment_job" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "title" varchar(255) NOT NULL, "slug" varchar(255) NOT NULL UNIQUE, "department" varchar(100) NOT NULL, "type" varchar(20) NOT NULL, "location" varchar(255) NOT NULL, "salary_range" varchar(100) NOT NULL, "experience" varchar(100) NOT NULL, "quantity" integer unsigned NOT NULL CHECK ("quantity" >= 0), "description" text NOT NULL, "benefits" text NOT NULL, "deadline" date NOT NULL, "is_active" bool NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "requirements" text NOT NULL)