test
Tables (19)
ALBUM
- ALB_ID — INT — Primary key — NOT NULL
- GROUP_ID — INT — Foreign key → GROUP.GROUP_ID — NOT NULL
- ALB_WRITER — VARCHAR(255) — NOT NULL
- ALB_IMG_PATH — VARCHAR(255) — NOT NULL
- ALB_REG_DATE — DATETIME
- ALB_AVAILABLE — BOOLEAN
ALBUM_COMMENT
- ALB_COMMENT_ID — INT — Primary key — NOT NULL
- GROUP_ID — INT — Foreign key → ALBUM.GROUP_ID — NOT NULL
- ALBUM_ID — INT — Foreign key → ALBUM.ALB_ID — NOT NULL
- ALB_COMMENT_WRITER — VARCHAR(255) — NOT NULL
- ALB_COMMENT_CONTENT — VARCHAR(255) — NOT NULL
- ALB_COMMENT_REG_DATE — DATETIME — NOT NULL
- ALB_COMMENT_MOD_DATE — DATETIME — NOT NULL
- ALB_COMMENT_AVAILABLE — BOOLEAN
BOARD
- ART_ID — INT — Primary key — NOT NULL
- GROUP_ID — INT — Foreign key → GROUP.GROUP_ID — NOT NULL
- ART_TITLE — VARCHAR(255) — NOT NULL
- ART_WRITER — VARCHAR(255) — NOT NULL
- ART_CONTENT — VARCHAR(255) — NOT NULL
- ART_IMG_PATH — VARCHAR(255)
- ART_VIEW_CNT — INT
- ART_REG_DATE — DATETIME
- ART_MOD_DATE — DATETIME
- ART_AVAILABLE — BOOLEAN
BOARD_COMMENT
- ART_COMMENT_ID — INT — Primary key — NOT NULL
- GROUP_ID — INT — Foreign key → BOARD.GROUP_ID — NOT NULL
- ART_ID — INT — Foreign key → BOARD.ART_ID — NOT NULL
- ART_COMMENT_WRITER — VARCHAR(255) — NOT NULL
- ART_COMMENT_CONTENT — VARCHAR(255) — NOT NULL
- ART_COMMENT_REG_DATE — DATETIME
- ART_COMMENT_MOD_DATE — DATETIME
- ART_COMMENT_AVAILABLE — BOOLEAN
CATEGORY
- CATEGORY_NAME — VARCHAR(255) — Primary key — NOT NULL
- CATEGORY_VALUE — VARCHAR(255) — NOT NULL
- CATEGORY_IMG_PATH — VARCHAR(255)
CHAT
- Key — INT — Primary key — NOT NULL
- GROUP_ID — INT — Foreign key → GROUP.GROUP_ID — NOT NULL
GROUP
- GROUP_ID — INT — Primary key — NOT NULL
- GROUP_TITLE — VARCHAR(255) — NOT NULL
- GROUP_CREATOR — VARCHAR(255) — NOT NULL
- GROUP_PRE_MBTI1 — INT — Foreign key → MBTI.MBTI_ID — NOT NULL
- GROUP_PRE_MBTI2 — INT — Foreign key → MBTI.MBTI_ID
- GROUP_PRE_MBTI3 — INT — Foreign key → MBTI.MBTI_ID
- GROUP_PRE_MBTI4 — INT — Foreign key → MBTI.MBTI_ID
- CATEGORY_NAME — VARCHAR(255) — Foreign key → CATEGORY.CATEGORY_NAME — NOT NULL
- GROUP_INTRODUCE — VARCHAR(255) — NOT NULL
- GROUP_LOCATION — VARCHAR(255) — NOT NULL
- GROUP_TUMB — VARCHAR(255)
- GROUP_MAXIMUM — INT — NOT NULL
- GROUP_RATE1 — DOUBLE
- GROUP_RATE2 — DOUBLE
- GROUP_RATE3 — DOUBLE
- GROUP_REG_DATE — DATETIME
- GROUP_AVAILABLE — BOOLEAN
LIKE_LIST
- USER_ID — VARCHAR(255) — Foreign key → USER.USER_ID — NOT NULL
- ALBUM_ID — INT — Foreign key → ALBUM.ALB_ID — NOT NULL
- GROUP_ID — INT — Foreign key → ALBUM.GROUP_ID — NOT NULL
MBTI
- MBTI_ID — INT — Primary key — NOT NULL
- MBTI_IMG_PATH — VARCHAR(255)
- MBTI_NAME — VARCHAR(255) — NOT NULL
MEMBER_FAV
- USER_ID — VARCHAR(255) — Foreign key → USER.USER_ID — NOT NULL
- GROUP_ID — INT — Foreign key → GROUP.GROUP_ID — NOT NULL
MEMBER_LIST
- USER_ID — VARCHAR(255) — Foreign key → USER.USER_ID — NOT NULL
- GROUP_ID — INT — Foreign key → GROUP.GROUP_ID — NOT NULL
QNA
- QNA_ID — VARCHAR(255) — Primary key — NOT NULL
- Question — VARCHAR(255) — NOT NULL
- Answer — VARCHAR(255) — NOT NULL
REPORT_BOARD
- REP_BOA_ID — INT — Primary key — NOT NULL
- REP_CATEGORY_NAME — VARCHAR(255) — Foreign key → REPORT_CATEGORY.REP_CATEGORY_NAME — NOT NULL
- REP_TITLE — VARCHAR(255) — NOT NULL
- REP_BOA_WRITER — VARCHAR(255) — Foreign key → USER.USER_ID — NOT NULL
- REP_BOA_CONTENT — VARCHAR(255) — NOT NULL
- REP_BOA_IMG_PATH — VARCHAR(255)
- REP_REG_DATE — DATETIME
REPORT_CATEGORY
- REP_CATEGORY_NAME — VARCHAR(255) — Primary key — NOT NULL
- REP_CATEGORY_VALUE — VARCHAR(255) — NOT NULL
- CATEGORY_IMG_PATH — VARCHAR(255)
REPORT_COMMENT
- REP_COM_ID — INT — Primary key — NOT NULL
- REP_BOA_ID — INT — Foreign key → REPORT_BOARD.REP_BOA_ID — NOT NULL
- REP_COM_WRITER — VARCHAR(255) — NOT NULL
- REP_COM_CONTENT — VARCHAR(255) — NOT NULL
- REP_COM_BOA_REG_DATE — DATETIME — NOT NULL
SCHEDULE
- SCH_ID — INT — Primary key — NOT NULL
- GROUP_ID — INT — Foreign key → GROUP.GROUP_ID — NOT NULL
- SCH_TITLE — VARCHAR(255) — NOT NULL
- SCH_WRITER — VARCHAR(255) — NOT NULL
- SCH_CONTENT — VARCHAR(255) — NOT NULL
- SCH_LOCATION — VARCHAR(255) — NOT NULL
- SCH_NOTE — VARCHAR(255) — NOT NULL
- SCH_MEMBER_COUNT — INT
- SCH_DATE — DATETIME — NOT NULL
- SCH_AVLILABLE — BOOLEAN
SCHEDULE_MEMBER
- USER_ID — VARCHAR(255) — Foreign key → USER.USER_ID — NOT NULL
- SCH_ID — INT — Foreign key → SCHEDULE.SCH_ID — NOT NULL
- GROUP_ID — INT — Foreign key → SCHEDULE.GROUP_ID — NOT NULL
SUBSCRIBE
- GROUP_ID — INT — Foreign key → GROUP.GROUP_ID — NOT NULL
- PRICE — INT — NOT NULL
- PAY_DAY — DATETIME — NOT NULL
- PERIODE — DATETIME — NOT NULL
USER
- USER_ID — VARCHAR(255) — Primary key — NOT NULL
- NAME — VARCHAR(255) — NOT NULL
- PASSWORD — VARCHAR(255) — NOT NULL
- BIRTHDAY — VARCHAR(255) — NOT NULL
- GENDER — VARCHAR(255) — NOT NULL
- LOCATION — VARCHAR(255) — NOT NULL
- PHONE_NUM — INT — NOT NULL
- JOIN_DATE — DATETIME — NOT NULL
- ADMIN — BOOLEAN
- PROFILE_IMAGE — VARCHAR(255)
- MODIFIED_DAY — DATETIME
- USER_AVAILABLE — BOOLEAN
- MBTI_PATH — VARCHAR(255)
- MBTI_ID — INT — Foreign key → MBTI.MBTI_ID — dd