import sys

from sqlite3 import *
from sqlalchemy import *
from sqlalchemy.ext.declarative import *
from sqlalchemy import Column, Integer, String
from sqlalchemy.orm import relationship

engine = create_engine("sqlite:///users.db")

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, Sequence('user_id_seq'), primary_key=True)
    name = Column(String(50))
    surname = Column(String(50))
    adress = relationship("Adress")
    email = relationship("Email")
    phone = relationship("Phone")
    others = relationship("User")

class Adress(Base):
    __tablename__ = 'adress'
    id = Column(Integer, Sequence('adress_id_seq'), primary_key=True)
    street = Column(String(50))
    number = Column(String(50))
    city = Column(String(50))

class Email(Base):
    __tablename__ = 'email'
    id = Column(Integer, Sequence('email_id_seq'), primary_key=True)
    adress = Column(String(50))

class Phone(Base):
    __tablename__ = 'phone'
    id = Column(Integer, Sequence('phone_id_seq'), primary_key=True)
    Number = Column(String(50))

Base.metadata.create_all(engine)