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)