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)