DBproject

Tables (7)

ATTANDANCE

  • ID — INT — Primary key — NOT NULL
  • TYPE_ID — INT — Foreign key → ATTANDANCE_TYPE.TYPE_ID — NOT NULL
  • MEMBER_ID — INT — Foreign key → MEMBER.ID — NOT NULL
  • CHECK_IN_TIME — TIMESTAMP

ATTANDANCE_TYPE

  • TYPE_ID (ID) — INT — Primary key — NOT NULL
  • TYPE_NAME — VARCHAR(255)

BOARD

  • ID — INT — Primary key — NOT NULL
  • AUTHOR — INT — Foreign key → MEMBER.ID — NOT NULL
  • TYPE — INT — Foreign key → BOARD_TYPE.TYPE_ID — NOT NULL
  • DATE — TIMESTAMP
  • TITLE — VARCHAR(255)
  • CONTENT
  • IS_NOTICE — TINYINT
  • IS_DELETED — TINYINT
  • VIEW — INT
  • Field

BOARD_TYPE

  • TYPE_ID (ID) — INT — Primary key — NOT NULL
  • CODE — VARCHAR(45)
  • FORCE_LOGIN — TINYINT
  • STAFF_ONLY — TINYINT

COMMENT

  • ID — INT — Primary key — NOT NULL
  • AUTHOR — INT — Foreign key → MEMBER.ID — NOT NULL
  • DATA — TEXT
  • DATE — TIMESTAMP
  • IS_DELETED — TINYINT
  • POST — INT — Foreign key → BOARD.ID — NOT NULL

MEMBER

  • ID — INT — Primary key — NOT NULL
  • UID — INT
  • NAME — VARCHAR(255)
  • PASSWORD — VARCHAR(255)
  • HASH1 — VARCHAR(255)
  • HASH2 — VARCHAR(255)
  • HASH3 — VARCHAR(255)
  • IS_STAFF — TINYINT

SURVEY (SERVEY)

  • ID — INT — Primary key — NOT NULL
  • TITLE — VARCHAR(255)
  • DESCRIPTION — VARCHAR(255)
  • Field
  • MEMBER_ID — INT — Foreign key → MEMBER.ID — NOT NULL