{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["data dictionary","menu_category","menu","promotion","header_order","detail_order","payment"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"data dictionary","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,0,2,0],[3,0,8,0],[9,0,14,0],[15,0,18,0],[19,0,23,0],[24,0,29,0]]}
["TABLE","KEY","COLUMN","REQUIRED","DATATYPE","NOTES"]
["menu_category","PK","id","Y","INT","Auto Increment"]
[null,null,"name","Y","VARCHAR(100)"]
["menu","PK","id","Y","INT","Auto Increment"]
[null,"FK","menu_category_id","Y","INT"]
[null,null,"name","Y","VARCHAR(100)"]
[null,null,"price","Y","DECIMAL(8, 2)"]
[null,null,"description",null,"VARCHAR(200)"]
[null,null,"is_favourite",null,"BIT"]
["promotion","PK","id","Y","INT","Auto Increment"]
[null,null,"code","Y","VARCHAR(20)"]
[null,null,"discount","Y","DECIMAL(5, 2)"]
[null,null,"minimum_spent","Y","DECIMAL(10, 2)"]
[null,null,"start_time","Y","DATETIME"]
[null,null,"end_time","Y","DATETIME"]
["header_order","PK","id","Y","INT","Auto Increment"]
[null,null,"order_made_time","Y","DATETIME"]
[null,null,"table_number","Y","INT"]
[null,null,"customer_name","Y","VARCHAR(100)"]
["detail_order","PK","id","Y","INT","Auto Increment"]
[null,"FK","header_order_id","Y","INT"]
[null,"FK","menu_id","Y","INT"]
[null,null,"order_price","Y","DECIMAL(8, 2)"]
[null,null,"quantity","Y","INT"]
["payment","PK","id","Y","INT","Auto Increment"]
[null,"FK","header_order_id","Y","INT"]
[null,"FK","promotion_id",null,"INT"]
[null,null,"payment_type","Y","VARCHAR(20)"]
[null,null,"amount_to_pay","Y","DECIMAL(10, 2)"]
[null,null,"amount_paid","Y","DECIMAL(10, 2)"]

{"sheet":"menu_category","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["id","name"]
[1,"Foods"]
[2,"Drinks"]
[3,"Snacks"]
[4,"Others"]

{"sheet":"menu","index":2,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["id","menu_category_id","name","price","description","is_favourite"]
[1,1,"Beef Martabak",55000,"With sour sweet sauce and pickles",1]
[2,1,"Spaghetti Bolognaise",97000,"Spaghettie with minced beef and tomato sauce",1]
[3,1,"Gado gado",50000,"Mixed boiled vegetable served with rice cake and peanut sauce",1]
[4,1,"Grilled Sirloin",200000,"Steak and fries served with mushroom sauce",0]
[5,1,"Deluxe Burger",45000,"Beef patty with melted extra double cheese, tomato, and pickle",0]
[6,1,"Iga Bakar",50000,"Served with Sambal Ijo, rice, and soup",1]
[7,2,"Tropical Punch",40000,"The perfect blend of cherry, orange and pineapple flavor",1]
[8,2,"Cappuccino",25000,null,0]
[9,2,"Juices",20000,"Avocado, Pineapple, Orange, Mango",0]
[10,2,"Mineral Water",10000,null,1]
[11,2,"Soft Drinks",15000,"Cola, Sprite, Fanta",1]
[12,3,"Cheese and choco pancake",30000,"With maple or rum sauce",1]
[13,3,"Ice Mochi",30000,"Salted Caramel, Rd Bean, Coffee, Green Tea, Chocolate",1]
[14,3,"Tiramisu",25000,null,0]
[15,4,"Miso Soup",10000,null,0]
[16,4,"Rice",10000,null,0]
[17,4,"Mushroom Steak Salad",30000,"Served with sesame or thousand islands dressing",0]
[18,4,"Spicy Edamame",20000,"Edamame served with chili flakes",0]

{"sheet":"promotion","index":3,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["id","code","discount","minimum_spent","start_time","end_time"]
[1,"HEMATBGT",20,150000,"2019-10-01","2019-10-31"]
[2,"KUMPULRAME",5,50000,"2019-10-01","2019-10-31"]
[3,"TANGGALTUA",10,100000,"2019-10-25","2019-10-31"]
[4,"ABISGAJIAN",5,75000,"2019-11-01","2019-11-07"]

{"sheet":"header_order","index":4,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["id","order_made_time","table_number","customer_name"]
[1,"2019-10-18T11:13:00",3,"Fanny"]
[2,"2019-10-18T12:00:23",1,"Rina"]
[3,"2019-10-18T13:00:56",3,"Reni"]
[4,"2019-10-18T13:28:00",4,"Budiman"]
[5,"2019-10-18T13:30:00",2,"Danu"]
[6,"2019-10-18T13:55:31",5,"Antika"]

{"sheet":"detail_order","index":5,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["id","header_order_id","menu_id","order_price","quantity"]
[1,1,6,50000,1]
[2,1,9,20000,1]
[3,2,2,97000,1]
[4,2,3,50000,1]
[5,2,10,10000,2]
[6,3,4,100000,1]
[7,3,6,50000,1]
[8,3,5,45000,2]
[9,3,9,20000,2]
[10,3,10,10000,4]
[11,4,1,55000,1]
[12,4,3,100000,2]
[13,3,15,10000,3]
[14,3,14,25000,1]
[15,5,17,30000,1]
[16,5,12,30000,1]

{"sheet":"payment","index":6,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["id","header_order_id","promotion_id","payment_type","amount_to_pay","amount_paid"]
[1,1,"NULL","Cash",80500,100000]
[2,2,2,"Credit",182447.5,182447.5]
[3,4,1,"Cash",142600,150000]