DB/Entity

• USER

  • INDEX (NUMBER)
  • USERID (VARCHAR)
  • PASSWORD(SHA256) (VARCHAR)
  • NAME (VARCHAR)
  • ROLE (VARCHAR)
  • USEYN (BOOL)
  • CREATEDT (DATETIME)

• FAVORITES

  • INDEX(NUMBER)
  • USERID (VARCHAR)
  • COINSYM (VARCHAR)

• COIN

  • INDEX (NUMBER)
  • COINSYM (VARCHAR)
  • COINNAME (VARCHAR)
  • USEYN (BOOL)

• BOARD

  • INDEX (NUMBER)
  • TITLE (VARCHAR)
  • CONTENTS (BLOB)
  • CONLIKE (NUMBER)
  • CONDISLIKE (NUMBER)
  • TYPE (NUMBER)
  • CREATEDT (DATETIME)
  • USEYN (BOOL)
  • USERID (VARCHAR)

• CHATTING

  • INDEX (NUMBER)
  • COINSYM (VARCHAR)