lotto

Tables (9)

Board

  • Board Id (board_Id) — INT — Primary key — NOT NULL
  • User Id (User_id) — INT — Foreign key → User.User Id — NOT NULL
  • Text (text) — VARCHAR
  • Title (title) — VARCHAR
  • Author (author) — VARCHAR
  • Date (date) — VARCHAR(255)

Board Comment (board_comment)

  • BoardCommnet Id (boardCommnet_Id) — INT — Primary key — NOT NULL
  • Board Id (board_Id) — INT — Foreign key → Board.Board Id — NOT NULL
  • User Id (User_id) — INT — Foreign key → User.User Id — NOT NULL
  • Text (text) — VARCHAR

Grade (grade)

  • Ticket Id (ticket_id) — INT — Foreign key → Ticket.Ticket Id — NOT NULL
  • Value (value) — INT
  • Field

Main Ticket (main_ticket)

  • MainTicket Id (mainTicket_id) — INT — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Image (image) — VARCHAR(255)
  • Price (price) — INT
  • Event (event) — VARCHAR(255)
  • Discount Rate (discount_rate) — INT
  • Field

Message (message)

  • Message Id (message_id) — INT — Primary key — NOT NULL
  • User Id (User_id) — INT — Foreign key → User.User Id — NOT NULL
  • Text (text) — VARCHAR
  • Sender (sender) — VARCHAR(20)
  • Reciver (reciver) — VARCHAR(20)

Payment (payment)

  • Payment Id (payment_Id) — INT — Primary key — NOT NULL
  • User Id (User_id) — INT — Foreign key → User.User Id — NOT NULL
  • Ticket Id (ticket_id) — INT — Foreign key → Ticket.Ticket Id — NOT NULL
  • Date (date) — VARCHAR(255)
  • Field
  • Field2
  • Field3

Ticket (ticket)

  • Ticket Id (ticket_id) — INT — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Date (date) — VARCHAR(255)
  • Time (time) — VARCHAR(255)
  • Price (price) — INT
  • Image (image) — VARCHAR(255)
  • Description (description) — VARCHAR(255)
  • Discount Rate (discount_rate) — INT

Ticket Comment (Ticket_comment)

  • Ticket Id (ticket_id) — INT — Foreign key → Ticket.Ticket Id — NOT NULL
  • User Id (User_id) — INT — Foreign key → User.User Id — NOT NULL
  • Text (text) — VARCHAR
  • Date (date) — VARCHAR(255)
  • Field
  • Field2
  • Field3

User (user)

  • User Id (User_id) — INT — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Email (email) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)