1. import sys
2.  
3. from sqlite3 import *
4. from sqlalchemy import *
5. from sqlalchemy.ext.declarative import *
6. from sqlalchemy import Column, Integer, String
7. from sqlalchemy.orm import relationship
8.  
9. engine = create_engine("sqlite:///users.db")
10.  
11. Base = declarative_base()
12.  
13. class User(Base):
14.     __tablename__ = 'users'
15.     id = Column(Integer, Sequence('user_id_seq'), primary_key=True)
16.     name = Column(String(50))
17.     surname = Column(String(50))
18.     adress = relationship("Adress")
19.     email = relationship("Email")
20.     phone = relationship("Phone")
21.     others = relationship("User")
22.  
23. class Adress(Base):
24.     __tablename__ = 'adress'
25.     id = Column(Integer, Sequence('adress_id_seq'), primary_key=True)
26.     street = Column(String(50))
27.     number = Column(String(50))
28.     city = Column(String(50))
29.  
30. class Email(Base):
31.     __tablename__ = 'email'
32.     id = Column(Integer, Sequence('email_id_seq'), primary_key=True)
33.     adress = Column(String(50))
34.  
35. class Phone(Base):
36.     __tablename__ = 'phone'
37.     id = Column(Integer, Sequence('phone_id_seq'), primary_key=True)
38.     Number = Column(String(50))
39.  
40. Base.metadata.create_all(engine)
41.  
42.