JanghowonTerminal

Tables (5)

Account

  • account_id — bigint — Primary key — NOT NULL — auto_increment
  • email — varchar(255)
  • password — varchar(255)
  • phone — varchar(255)
  • role — varchar(255)
  • username — varchar(255)

AccountBusInfo

  • account_businfo_id — bigint — Primary key — NOT NULL
  • note — varchar(255)
  • account_id — varchar — Foreign key → Account.account_id — NOT NULL — auto_increment
  • businfo_id — varchar — Foreign key → BusInfo.businfo_id — NOT NULL

Board

  • board_id — bigint — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • content — text
  • title — varchar(255)
  • writer — varchar(255)
  • account_id — bigint — Foreign key → Account.account_id — NOT NULL — auto_increment

BusInfo

  • businfo_id — bigint — Primary key — NOT NULL
  • arrival — varchar(255)
  • departtime — varchar(255)
  • layover — varchar(255) — NOT NULL
  • note — varchar(255) — NOT NULL

Comment

  • comment_id — bigint — Primary key — NOT NULL
  • content — text
  • writer — varchar(255)
  • board_id — bigint — Foreign key → Board.board_id — NOT NULL