test.dbml

//// -- LEVEL 1
//// -- Tables and References

Project test {
  database_type: 'PostgreSQL'
  Note: 'Description of the project'
}

// Creating tables
Table users as U {
  id int [pk, unique, increment] // auto-increment
  full_name varchar [not null, unique, default: 1]
  created_at timestamp
  country_code int
  type int
  note int
  Note: 'khong hieu duoc'
}

Table merchants {
  id int [pk]
  merchant_name varchar
  country_code int [not null]
  'created at' varchar
  admin_id int [ref: > U.id] // inline relationship (many-to-one)
}

Table countries {
  code int [pk]
  name varchar
  continent_name varchar
}

Table Action {
  id int
  act varchar(20)
}

// Creating references
// You can also define relaionship separately
// > many-to-one; < one-to-many; - one-to-one
Ref{
  U.country_code > countries.code  
  merchants.country_code > countries.code
}

//----------------------------------------------//

//// -- LEVEL 2
//// -- Adding column settings

Table order_items {
  order_id int [ref: > orders.id]
  product_id int    
  quantity int [default: 1] // default value
}

Ref: order_items.product_id > products.id

Table orders {
  id int [pk] // primary key
  user_id int [not null, unique]
  status varchar
  created_at varchar [note: '''When order created'''] // add column note
}

Table int {
  id int
}

//----------------------------------------------//

//// -- Level 3 
//// -- Enum, Indexes

// Enum for 'products' table below
Enum products_status {
  out_of_stock
  in_stock
  running_low [note: 'less than 20'] // add column note
}

// Indexes: You can define a single or multi-column index 
Table products {
  id int [pk]
  name varchar
  merchant_id int [not null]
  price int
  status products_status
  created_at datetime [default: `now()`]
  
  Indexes {
    (merchant_id, status) [name:'product_status', type: hash]
    id [unique]
  }
}

enum keywords_as_enum {
  key
  default
  type
}

Ref: products.merchant_id > merchants.id // many-to-one

TableGroup hello_world {
    just_test
    just_a_test
}

// Index: have a column names 'key' as part of an index
Table items1 {
  key int [pk] // primary key
  user_id int [not null, unique]
  status varchar
  Indexes {
      (key) [unique]
    }
}

Table items2 {
  key int [pk] // primary key
  order_id int [not null, unique]
  status varchar
  Indexes {
      (key, order_id) [name: 'some_name', unique]
    }
}

// Index: have a keywords - Action, Type, Section, Project, Default - fields as part of an index
Table action1 {
  action int [pk] // primary key
  order_id int [not null, unique]
  status varchar
  type varchar
  Indexes {
      (action, order_id) [name: 'some_name', unique]
      (type, section, project, default) [name: 'keywords_as_index', unique]
    }
}