Tra.B
Tables (16)
Account
- Account_id — INT(6) — Primary key — NOT NULL
- Account_number — INT(16) — NOT NULL
- Account_name — VARCHAR(10) — NOT NULL
- Account_registration_date — DATETIME — NOT NULL
- Is_disable — BIT(1) — NOT NULL
- Bank_id (Bank-id) — INT(5) — Foreign key → Bank.Bank_id — NOT NULL
- User_id — INT(5) — Foreign key → User.User_id — NOT NULL
Bank
- Bank_id (Bank-id) — INT(5) — Primary key — NOT NULL
- Bank_name — VARCHAR(10) — NOT NULL
- Bank_account_size — INT(2) — NOT NULL
- Bank_logo — TEXT
Card_Company
- Card_Company_id — INT(5) — Primary key — NOT NULL
- Card_Company_name — VARCHAR(10) — NOT NULL
Cart
- Cart_id — INT(5) — Primary key — NOT NULL
- Diary_id — INT(5) — Foreign key → Diary.Diary_id — NOT NULL
- User_id — INT(5) — Foreign key → User.User_id — NOT NULL
Category
- Category_id — INT(5) — Primary key — NOT NULL
- Create_date — DATETIME — NOT NULL
- Category_name — VARCHAR(10) — NOT NULL
Comment
- Comment_id (Key) — INT(5) — Primary key — NOT NULL
- Comment_text — TEXT — NOT NULL
- User_id — INT(5) — Foreign key → User.User_id — NOT NULL
Content
- Content_id — INT(5) — Primary key — NOT NULL
- Version — INT(5) — NOT NULL
- Create_date — DATETIME — NOT NULL
- Text — TEXT — NOT NULL
- Last_change — DATETIME — NOT NULL
- Latitude — DECIMAL(10, 8) — NOT NULL
- Longitude — DECIMAL(10, 8) — NOT NULL
Content_file
- File_id — INT(10) — Foreign key → File.File_id — NOT NULL
- Content_id — INT(5) — Foreign key → Content.Content_id — NOT NULL
Diary
- Diary_id — INT(5) — Primary key — NOT NULL
- Diary_name — VARCHAR(20) — NOT NULL
- Category_id — INT(5) — Foreign key → Category.Category_id — NOT NULL
- Content_id — INT(5) — Foreign key → Content.Content_id — NOT NULL
- Comment_id (Key) — INT(5) — Foreign key → Comment.Comment_id — NOT NULL
- User_id — INT(5) — Foreign key → User.User_id — NOT NULL
- View_count — INT(8) — NOT NULL
- Group_id — INT(5) — Foreign key → Group_code.Group_id — NOT NULL
- Price — INT(10) — NOT NULL
File
- File_id — INT(5) — Primary key — NOT NULL
- File_size — INT(10) — NOT NULL
- File_Name — VARCHAR(20) — NOT NULL
- File_type — VARCHAR(10) — NOT NULL
- Field — TEXT — NOT NULL
Group_code
- Group_id — INT(5) — Primary key — NOT NULL
- Group_name — VARCHAR(10) — NOT NULL
Order
- Order_id — INT(5) — Primary key — NOT NULL
- Payment_id — INT(5) — Foreign key → Payment.Payment_id — NOT NULL
- Diary_id — INT(5) — Foreign key → Diary.Diary_id — NOT NULL
- User_id — INT(5) — Foreign key → User.User_id — NOT NULL
Payment
- Payment_id — INT(5) — Primary key — NOT NULL
- Payment_date — DATETIME — NOT NULL
- Payment_price — INT(10) — NOT NULL
- Payment_Method_id — INT(5) — Foreign key → Payment_Method.Payment_Method_id — NOT NULL
- User_id — INT(5) — Foreign key → User.User_id — NOT NULL
Payment_Method
- Payment_Method_id — INT(5) — Primary key — NOT NULL
- Payment_Method_name — VARCHAR(10) — NOT NULL
- Payment_Method_number — INT(16) — NOT NULL
- Payment_Method_period — DATE — NOT NULL
- Card_Company_id — INT(5) — Foreign key → Card_Company.Card_Company_id — NOT NULL
User
- User_id — INT(5) — Primary key — NOT NULL
- Email — varchar(50) — NOT NULL
- Gender — BIT(1)
- Password — INT(12) — NOT NULL
- Create_Date — DATETIME — NOT NULL
- NickName — VARCHAR(10) — NOT NULL
- Username — VARCHAR(20) — NOT NULL
- Is_delete — BIT(1) — NOT NULL
- Birth — DATE
- Auth — INT(9) — NOT NULL
Vote
- Vote_id — INT(5) — Primary key — NOT NULL
- User_id — INT(5) — Foreign key → User.User_id — NOT NULL
- Diary_id — INT(5) — Foreign key → Diary.Diary_id — NOT NULL