KB_Platform

Tables (7)

Account (account)

  • acc_num — char(30) — Primary key — NOT NULL
  • user_id — char(15) — Foreign key → User.user_id — NOT NULL
  • acc_pwd — int
  • acc_type — char(50)
  • acc_name — varchar(20)
  • created_at — datetime
  • updated_at — datetime
  • total — int
  • acc_detail — char(50)

Benefit (benefit)

  • benefit_id — int — Primary key — NOT NULL
  • card_id — int — Foreign key → Card.card_id — NOT NULL
  • service_name — varchar(20)
  • percent — int
  • use_stand — text
  • month_stand — text
  • benefit_type — int

Card (card)

  • card_id — int — Primary key — NOT NULL
  • card_name — varchar(20)
  • card_type — int
  • card_img — image

LSTM (lstm)

  • id — int — Primary key — NOT NULL
  • date — date
  • act — int

Review (review)

  • review_id — int — Primary key — NOT NULL
  • user_id — char(15) — Foreign key → User.user_id — NOT NULL
  • review — text
  • created_at — datetime
  • updated_at — datetime

Trans (trans)

  • trans_id — int — Primary key — NOT NULL
  • acc_num — char(30) — Foreign key → Account.acc_num — NOT NULL
  • user_id — char(15) — Foreign key → Account.user_id — NOT NULL
  • trans_date — date
  • trans_content — char(30)
  • trans_type — char(50)
  • trans_price — int

User (user)

  • user_id — char(15) — Primary key — NOT NULL
  • user_pwd — char(20)
  • user_name — varchar(20)
  • check_cnt — int(2)