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)