Notes
Notes - notes.io |
id int not null primary key auto_increment,
product_name varchar(255) not null,
product_stock_code varchar(255) unique not null,
product_stock int DEFAULT '0',
product_price double DEFAULT '0.0',
product_price_currency int not null,
product_description varchar(10000,
tax_rate double,
tax_included tinyint(1) DEFAULT '1'
)
CREATE TABLE product_images(
id int not null primary key auto_increment,
product_id int,
image_path varchar(1000)
)
CREATE TABLE product_drivers(
id int not null primary key auto_increment,
product_id int not null,
driver_link varchar(10000) not null,
driver_header varchar(255) not null
)
CREATE TABLE users(
id int not null primary key auto_increment,
company_name varchar(255) not null,
company_code varchar(255),
company_address varchar(1000),
company_country int not null,
username varchar(255) not null unique,
password varchar(255) not null,
last_ip varchar(15)
)
CREATE TABLE orders(
id int not null primary key auto_increment,
user_id int not null,
order_total_price double COMMENT 'Toplam vergi dahil fiyat.',
order_total_tax double COMMENT 'Toplam vergi fiyat.',
order_total_income double COMMENT 'Toplam vergi harici fiyat.',
order_quantity int,
order_date datetime,
order_currency int not null,
order_unique_uuid char(36) not null unique
)
CREATE TABLE order_details(
id int not null primary key auto_increment,
product_id int not null,
order_id int not null,
quantity int not null,
tax_rate double not null,
total_price double not null COMMENT 'Toplam vergi dahil fiyat.',
total_tax double not null COMMENT 'Toplam vergi fiyat.',
total_income double not null COMMENT 'Toplam vergi harici fiyat.'
)
CREATE TABLE administrators(
id int not null primary key auto_increment,
username varchar(255) not null unique,
password varchar(255) not null,
name varchar(255) not null,
surname varchar(255) not null,
permission_id int not null
)
CREATE TABLE administrator_logins(
id int not null primary key auto_increment,
administrator_id int not null,
login_date datetime not null,
login_ip varchar(50) not null
)
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
