Database description - Nomarta/apple-collection GitHub Wiki

apple_collection

client

• id INT
• name VARCHAR(255)
• photo VARCHAR(255)
• description TEXT

order

• id INT
• client_id INT
• type_id INT
• quantity INT
• payment_method ENUM
• is_paid BOOLEAN
• description TEXT

type

• id INT
• name VARCHAR(255)
• photo VARCHAR(255)
• default_price INT
• description TEXT

apple_cupboard

• id INT
• type_id INT
• quantity INT