SMS
Tables (6)
tb_board
- boardno — int(100) — Primary key — NOT NULL
- boardname — varchar(30)
- content — varchar(500)
- file — varchar(100)
- regdate — date
- viewCount — int(100)
- delflg — int(2)
- userno — int(100) — NOT NULL
- userno (userno2) — int(100) — Foreign key → tb_user.userno — NOT NULL
tb_board_good
- boardno — int(100) — NOT NULL
- goodCheck — boolean
- userno — int(100) — NOT NULL
- boardno (boardno2) — int(100) — Foreign key → tb_board.boardno — NOT NULL
- userno (userno2) — int(100) — Foreign key → tb_user.userno — NOT NULL
tb_profile
- userno — int(100) — NOT NULL
- school — varchar(20)
- company — varchar(20)
- regdate — varchar(20)
- delflg — int(2)
- userno (userno2) — int(100) — Foreign key → tb_user.userno — NOT NULL
tb_reply
- replyno — int(10) — Primary key — NOT NULL
- boardno — int(100) — NOT NULL
- replycontent — varchar(100)
- regdate — date
- delflg — int(2)
- userno — int(100) — NOT NULL
- boardno (boardno2) — int(100) — Foreign key → tb_board.boardno — NOT NULL
- userno (userno2) — int(100) — Foreign key → tb_user.userno — NOT NULL
tb_user
- userno — int(100) — Primary key — NOT NULL
- userid — varchar(20)
- password — varchar(20)
- email — varchar(20)
- username — varchar(10)
- regdate — date
- delflg — int(2)
tb_user_friend
- email — varchar(20)
- username — varchar(10)
- regdate — date
- delflg — int(2)
- userid — varchar(20)
- relationship — varchar(10)
- userno — int(100) — Foreign key → tb_user.userno — NOT NULL