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