난 DB Browser for SQLite - C:\Users\ACER\Downloads\Company SOLite(2).db File Edit View Tools Help New Database Open Database Write Changes Revert Changes Open Project Save Project Altach Database X Close Database Database Structure Execute So Browse Data Create Index Edit Pragmas Print Create Table Type Schema Name Tables (9) > 5 customer > is dept > is emp > is_inventory > is_item > S_ord > os product > ms_region > s_warehouse Indices (0) Views (0) Triggers (0) CREATE TABLE "s customer" ( "id" INTEGER, "name" TEXT, "phone" TEXT, "address" TEXT, "city" TEXT, "state" TEXT, "country" TEXT, "zip code" TEXT, "credit ra CREATE TABLE "s_dept" ( "id" INTEGER, "name" TEXT, "region_id" INTEGER, FOREIGN KEY("region_id") REFERENCES "s_region"("id"), PRIMARY KEY("id")) CREATE TABLE "s_emp" ( "id" INTEGER, "last_name" TEXT, "first_name" TEXT, "userid" TEXT, "start_date" TEXT,"comments" TEXT, "manager_id" TEXT, "title" CREATE TABLE "s_inventory" ("product_id" INTEGER, "warehouse_id" INTEGER, "amount_in_stock" INTEGER, "reorder_point" INTEGER, "max_in_stock" INTEGER CREATE TABLE "s_item" ( "ord_id" INTEGER, "item_id" INTEGER,"product_id" INTEGER, "price" REAL, "quantity" INTEGER, "quantity_shipped" INTEGER, FOREIGN CREATE TABLE "s_ord" ( "id" INTEGER, "customer_id" INTEGER, "date_ordered" TEXT, "date_shipped" TEXT, "sales_rep_id" INTEGER, "total" INTEGER, "payment CREATE TABLE "s_product" ( "id" INTEGER, "name" TEXT, "short_desc" TEXT, "suggested_whlsl_price" REAL, "whlsl_units" TEXT, PRIMARY KEY("id")) CREATE TABLE "s_region" ( "id" INTEGER, "name" TEXT, PRIMARY KEY("id")) CREATE TABLE "s_warehouse" ( "id" INTEGER, "region_id" INTEGER, "address" TEXT,"city" TEXT, "state" TEXT, "country" TEXT, "zip_code" TEXT, "phone" TEXT, UTF-8 H Type here to search O - a a W 33☌ ADO Dat 0 ENG 12:47 08-08-2021ĭB Browser for SQLite - C:\Users\ACER\Downloads\Company SOLite(2).db File Edit View Tools Help New Database Open Database Write Changes Revert Changes Open Project Save Project Attach Database X Close Database Database Structure Edit Pragmas Execute SQL Browse Data Create Index Create Table Modify Table Delete Table Print Type Schema Name Tables (9) 5 customer Did name phone address city state country zip_code credit_rating sales_rep_id region_id comments 5 dept Did name region_id is emp id last_name first name userid start_date comments manager_id INTEGER TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT INTEGER TEXT CREATE TABLE 'S customer" ( "id" INTEGER, "name" TEXT, "phone" TEXT, "address" TEXT,"city" TEXT, "state" TEXT, "country" TEXT, "zip code" TEXT, "credit "id" INTEGER "name" TEXT "phone" TEXT "address" TEXT "city" TEXT "state" TEXT "country" TEXT "zip_code" TEXT "credit_rating" TEXT "zip_code" TEXT "sales_rep_id" TEXT "region_id" INTEGER "comments" TEXT CREATE TABLE "s_dept" ( "id" INTEGER, "name" TEXT, "region_id" INTEGER, FOREIGN KEY("region_id") REFERENCES "s_region"("id"), PRIMARY KEY("id")) "id" INTEGER "name" TEXT "region id" INTEGER CREATE TABLE "s_emp" ( "id" INTEGER, "last_name" TEXT, "first_name" TEXT,"userid" TEXT, "start_date" TEXT, "comments" TEXT, "manager_id" TEXT, "title "id" INTEGER "last_name" TEXT "first_name" TEXT "userid" TEXT "start_date" TEXT "comments" TEXT "manager_id" TEXT INTEGER TEXT INTEGER INTEGER TEXT TEXT TEXT TEXT TEXT TEXT UTF-8 H Type here to search o E: 1 a W 30☌ A » a 0 0 ENG 12:43 08-08-2021
0 kommentar(er)
