선문대 동아리 어플 ERD
테이블 (10)
ACT_DIARY
- ACT_ID — varchar(20) — 기본 키 — NOT NULL
- CLUB_ID — varchar(20) — 외래 키 → CLUB.CLUB_ID — NOT NULL
- STDNT_INNB — varchar(10) — 외래 키 → MBER_INFO.STDNT_INNB — NOT NULL
- SJ — varchar(100) — NOT NULL
- CN — text
- ATCH_PHOTO — text
- NMPR — int(4) — NOT NULL
- OTHBC_AT — bool — NOT NULL
- ACT_BEGIN_DT — varchar(14) — NOT NULL
- ACT_END_DT — varchar(14) — NOT NULL
- CREATE_DT — varchar(14) — NOT NULL
- UPDT_DT — varchar(14)
CLUB
- CLUB_ID — varchar(20) — 기본 키 — NOT NULL
- STDNT_INNB — varchar(10) — 외래 키 → MBER_INFO.STDNT_INNB — NOT NULL
- NM — varchar(100) — NOT NULL
- ATCH_PHOTO — text
- CTGRY — varchar(20) — NOT NULL
- MXMM_NMPR — int(4) — NOT NULL
- INTRCN_CN — varchar(1000)
- EXCLNC_AT — bool — NOT NULL
- EXCLNC_CO — bit — NOT NULL
- CREATE_DT — varchar(14) — NOT NULL
- UPDT_DT — varchar(14)
CLUB_MBER
- CLUB_ID — varchar(20) — 외래 키 → CLUB.CLUB_ID — NOT NULL
- STDNT_INNB — varchar(10) — 외래 키 → MBER_INFO.STDNT_INNB — NOT NULL
- RSPOFC — varchar(20) — NOT NULL
- RCRIT_PBLANC_AUTHOR — bool — NOT NULL
- ACT_DIARY_AUTHOR — bool — NOT NULL
- NOTICE_AUTHOR — bool — NOT NULL
CODE_INFO
- CODE — varchar(20) — 기본 키 — NOT NULL
- TY — varchar(20) — 외래 키 → CODE_TY_INFO.TY — NOT NULL
- CODE_NM — varchar(20)
- DC — varchar(255)
- SORT_ORDR — int(3)
- DELETE_AT — bool
- CREATE_DT — varchar(14)
- UPDT_DT — varchar(14)
CODE_TY_INFO
- TY — varchar(20) — 기본 키 — NOT NULL
- CODE_TY_NM — varchar(20)
- DC — varchar(255)
- DELETE_AT — bool
- CREATE_DT — varchar(14)
- UPDT_DT — varchar(14)
MBER_INFO
- STDNT_INNB — varchar(10) — 기본 키 — NOT NULL
- NM — varchar(20) — NOT NULL
- USID — varchar(20) — NOT NULL
- PASSWORD — varchar(20) — NOT NULL
- ATCH_PHOTO — text
- MAJOR — varchar(20) — NOT NULL
- GRADE — bit
- CTTPC — varchar(20) — NOT NULL
- EMAIL — varchar(50) — NOT NULL
- SRVMNGH — varchar(20) — NOT NULL
- NTCN_ESTBS — bool — NOT NULL
- USE_STPLAT_AGRE_AT — bool — NOT NULL
- USE_STPLAT_AGRE_DT — varchar(14)
- CREATE_DT — varchar(14) — NOT NULL
- UPDT_DT — varchar(14)
NOTICE
- NOTICE_ID — varchar(20) — 기본 키 — NOT NULL
- CLUB_ID — varchar(20) — 외래 키 → CLUB.CLUB_ID — NOT NULL
- STDNT_INNB — varchar(10) — 외래 키 → MBER_INFO.STDNT_INNB — NOT NULL
- CN — text
- ATCH_PHOTO — text
- CREATE_DT — varchar(14)
RCRIT_PBLANC
- RCRIT_PBLANC_ID — varchar(20) — 기본 키 — NOT NULL
- CLUB_ID — varchar(20) — 외래 키 → CLUB.CLUB_ID — NOT NULL
- STDNT_INNB — varchar(10) — 외래 키 → MBER_INFO.STDNT_INNB — NOT NULL
- SJ — varchar(100) — NOT NULL
- CN — text
- ATCH_PHOTO — text
- NMPR — int(4) — NOT NULL
- RDCNT — int(7) — NOT NULL
- RCRIT_AT — bool — NOT NULL
- RCRIT_BEGIN_DT — varchar(14) — NOT NULL
- RCRIT_END_DT — varchar(14) — NOT NULL
- PULLUP_DT — varchar(14)
- CREATE_DT — varchar(14) — NOT NULL
- UPDT_DT — varchar(14)
REQSTDOC_QESTN
- QESTN_ID — int(1) — 기본 키 — NOT NULL
- RCRIT_PBLANC_ID — varchar(20) — 외래 키 → RCRIT_PBLANC.RCRIT_PBLANC_ID — NOT NULL
- CLUB_ID — varchar(20) — 외래 키 → RCRIT_PBLANC.CLUB_ID — NOT NULL
- QESTN — varchar(100) — NOT NULL
REQST_DTLS
- STDNT_INNB — varchar(10) — 외래 키 → MBER_INFO.STDNT_INNB — NOT NULL
- CLUB_ID — varchar(20) — 외래 키 → REQSTDOC_QESTN.CLUB_ID — NOT NULL
- RCRIT_PBLANC_ID — varchar(20) — 외래 키 → REQSTDOC_QESTN.RCRIT_PBLANC_ID — NOT NULL
- QESTN_ID — int(1) — 외래 키 → REQSTDOC_QESTN.QESTN_ID — NOT NULL
- ANSWER — text — NOT NULL
- CREATE_DT — varchar(14) — NOT NULL
- UPDT_DT — varchar(14)