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