Mushion

Tables (10)

article

  • id — INT — Primary key — NOT NULL
  • memberId — INT — Foreign key → member.id — NOT NULL
  • boardId — INT — Foreign key → board.id — NOT NULL
  • regDate — DATETIME — NOT NULL
  • updateDate — DATETIME — NOT NULL
  • title — CHAR(50) — NOT NULL
  • body — TEXT — NOT NULL
  • hitCount — INT — NOT NULL
  • goodReactionPoint — INT — NOT NULL
  • badReactionPoint — INT — NOT NULL

board

  • id — INT — Primary key — NOT NULL
  • regDate — DATETIME — NOT NULL
  • updateDate — DATETIME — NOT NULL
  • code — CHAR(20) — NOT NULL
  • name — CHAR(20) — NOT NULL

fashionStyle

  • id — INT — Primary key — NOT NULL
  • styleName — VARCHAR — NOT NULL

genFile

  • id — INT(10) — Primary key — NOT NULL
  • regDate — DATETIME
  • updateDate — DATETIME
  • delDate — DATETIME
  • delStatus — TINYINT(1) — NOT NULL
  • relTypeCode — CHAR(50) — NOT NULL
  • relId — INT(10) — NOT NULL
  • originFileName — VARCHAR(100) — NOT NULL
  • fileExt — CHAR(10) — NOT NULL
  • typeCode — CHAR(20) — NOT NULL
  • type2Code — CHAR(20) — NOT NULL
  • fileSize — INT(10) — NOT NULL
  • fileExtTypeCode — CHAR(10) — NOT NULL
  • fileExtType2Code — CHAR(10) — NOT NULL
  • fileNo — SMALLINT(2) — NOT NULL
  • fileDir — CHAR(20) — NOT NULL
  • id (id2) — INT — Foreign key → article.id — NOT NULL

member

  • id — INT — Primary key — NOT NULL
  • regDate — DATETIME — NOT NULL
  • updateDate — DATETIME — NOT NULL
  • loginId — CHAR(20) — NOT NULL
  • loginPw — CHAR(20) — NOT NULL
  • name — CHAR(20) — NOT NULL
  • nickname — CHAR(20) — NOT NULL
  • email — CHAR(50) — NOT NULL
  • cellphoneNum — CHAR(20) — NOT NULL

musicType

  • id — INT — Primary key — NOT NULL
  • typeName — VARCHAR — NOT NULL

reactionPoint

  • id — INT — Primary key — NOT NULL
  • memberId — INT — Foreign key → member.id — NOT NULL
  • regDate — DATETIME — NOT NULL
  • updateDate — DATETIME — NOT NULL
  • relTypeCode — CHAR(20) — NOT NULL
  • relId — INT — NOT NULL
  • point — INT — NOT NULL

reply

  • id — INT — Primary key — NOT NULL
  • memberId — INT — Foreign key → member.id — NOT NULL
  • regDate — DATETIME
  • updateDate — DATETIME
  • relTypeCode — CHAR(20)
  • relId — INT
  • body — TEXT
  • goodReactionPoint — INT
  • badReactionPoint — INT
  • id (id2) — INT — Foreign key → article.id — NOT NULL

snapshotUrl

  • id — INT — NOT NULL
  • url — TEXT
  • fashionStyleId — INT — Foreign key → fashionStyle.id — NOT NULL

topdb

  • id — INT — NOT NULL
  • genre — VARCHAR(50)
  • artist — VARCHAR(50)
  • track — VARCHAR(50)