foodelivery_v1.yaml

tables:
  user:
    columns:
      - name: user_id
        type: integer
        primary_key: true
        
      - name: firstname
        type: varchar
        length: 20
        
      - name: lastname
        type: varchar
        length: 20
        
      - name: dob
        type: date
        
      - name: contact
        type: numeric
        nullable: false
        unique: true
        
      - name: address
        type: varchar
        length: 200
        
  order:
    columns:
      - name: order_id
        type: integer
        primary_key: true
        
      - name: hotel_name
        type: varchar
        length: 100
        
      - name: order_date
        type: date

      - name: amount
        type: float
        
      - name: user_id
        type: integer
        foreign_key: user.user_id