Board
Tables (6)
Chat
- chat_id — INT — Primary key — NOT NULL
- content — TEXT
- is_anonymous (isAnonymous) — BOOLEAN
- createdAt — VARCHAR(255)
- deletedAt — VARCHAR(255)
- post_id (Key2) — INT — Foreign key → Post.post_id — NOT NULL
- user_id (Key3) — INT — Foreign key → User.user_id — NOT NULL
Post
- post_id (Key) — INT — Primary key — NOT NULL
- title — VARCHAR(40)
- content — TEXT
- type — VARCHAR(20)
- attachment (Field5) — VARCHAR(255)
- is_anonymous — BOOLEAN
- createdAt — VARCHAR(255)
- deletedAt — VARCHAR(255)
- user_id — INT — Foreign key → User.user_id — NOT NULL
- space_id — INT — Foreign key → Space.space_id — NOT NULL
Space
- space_id — INT — Primary key — NOT NULL
- space_name — VARCHAR(40)
- logo — VARCHAR(255)
- admin_code (adminCode) — VARCHAR(8)
- participant_code (participantCode) — VARCHAR(8)
- createdAt — VARCHAR(255)
- updatedAt — VARCHAR(255)
- deletedAt — VARCHAR(255)
Space_Role
- spaceRole_id — INT — Primary key — NOT NULL
- spaceRole_name (name) — VARCHAR(40)
- is_admin (isAdmin) — BOOLEAN
- createdAt — VARCHAR(255)
- updatedAt — VARCHAR(255)
- deletedAt — VARCHAR(255)
- space_id — INT — Foreign key → Space.space_id — NOT NULL
User
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(40)
- password — VARCHAR(20)
- first_name — VARCHAR(20)
- last_name — VARCHAR(20)
- profile_picture — VARCHAR(255)
- createdAt — VARCHAR(255)
- updatedAt — VARCHAR(255)
- deletedAt — VARCHAR(255)
User_Space
- userSpace_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.user_id — NOT NULL
- space_id — INT — Foreign key → Space.space_id — NOT NULL
- spaceRole_id — INT — Foreign key → Space_Role.spaceRole_id — NOT NULL