mkboard
Tables (6)
COMMENT
- COMMENT_ID — INT — Primary key — NOT NULL
- FILE_POST_ID — INT — Foreign key → FILE_BOARD.POST_ID — NOT NULL
- AUTHOR — INT — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- CONTENT — VARCHAR(500) — NOT NULL
FILE_ATTACHMENT
- FILE_ID — INT — Primary key — NOT NULL
- FILE_POST_ID — INT — Foreign key → FILE_BOARD.POST_ID — NOT NULL
- FILE_ORIGINAL_NAME — VARCHAR(100) — NOT NULL
- FILE_SIZE — VARCHAR(100) — NOT NULL
- FILE_DIR — VARCHAR(200) — NOT NULL
- IS_FILE_DEL — BOOLEAN
FILE_BOARD
- POST_ID — INT — Primary key — NOT NULL
- AUTHOR — INT — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- TITLE — VARCHAR(100) — NOT NULL
- CONTENT — VARCHAR(4000)
- STATUS — VARCHAR(10) — NOT NULL
- CREATION_DATE — TIMESTAMP
- PROCESSING_DATE — TIMESTAMP
- PROCESSOR — VARCHAR(20)
- IS_DEL — BOOLEAN
- DELETION_DATE — TIMESTAMP
- TOKEN — VARCHAR(30)
MEMBER
- MEMBER_ID — INT — Primary key — NOT NULL
- USERNAME — VARCHAR(20) — NOT NULL
- PASSWORD — VARCHAR(100) — NOT NULL
- NAME — VARCHAR(20) — NOT NULL
- EMAIL — VARCHAR(30) — NOT NULL
- STATUS — VARCHAR(10) — NOT NULL
- MEMBER_ROLE — VARCHAR(20) — NOT NULL
- REGISTRATION_DATE — TIMESTAMP — NOT NULL
- REGISTRATION_TYPE — VARCHAR(10) — NOT NULL
- REGISTRANT — VARCHAR(20) — NOT NULL
- MODIFICATION_DATE — TIMESTAMP
- MODIFIER — VARCHAR(20)
- PASSWORD_ALERT — BOOLEAN
- IS_DEL — BOOLEAN
- DELETION_DATE — TIMESTAMP
NOTICE_BOARD
- POST_ID — INT — Primary key — NOT NULL
- AUTHOR — INT — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- TITLE — VARCHAR(100) — NOT NULL
- CONTENT — VARCHAR(4000) — NOT NULL
- CREATION_DATE — TIMESTAMP
- MODIFICATION_DATE — TIMESTAMP
- MODIFIER — VARCHAR(20)
- IS_DEL — BOOLEAN
- DELETION_DATE — TIMESTAMP
RESET_PASSWORD_TOKEN
- TOKEN_ID — INT — Primary key — NOT NULL
- TOKEN — VARCHAR(30) — NOT NULL
- EMAIL — VARCHAR(30) — NOT NULL
- TOKEN_EXPIRED — BOOLEAN
- TOKEN_EXPIRATION_DATE — TIMESTAMP