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