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