santa

Tables (6)

Donation

  • id — Primary key — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL
  • amount
  • create_at
  • update_at

Message

  • id — Primary key — NOT NULL
  • tree_id — Foreign key → Tree.id — NOT NULL
  • user_id
  • content
  • create_at
  • update_at

Payment

  • id — Primary key — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL
  • tier
  • status
  • payment_date
  • create_at
  • update_at

Tree

  • id — Primary key — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL
  • tree_name
  • create_at
  • update_at
  • Field

Tree_group

  • id — Primary key — NOT NULL
  • tree_name
  • create_at
  • update_at
  • Field

User

  • id — Primary key — NOT NULL
  • nickname (nick_name)
  • username (user_name)
  • email
  • mobile_no
  • create_at
  • update_at