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