colla
Tables (8)
board (게시판)
- Key — int — Primary key — NOT NULL — auto_increment
- Key (Key2) — integer — Foreign key → users.Key
- Field — string(31) — NOT NULL
- Field2 — string — NOT NULL
- Field3 — mediumtext
- Field4 — datetime — NOT NULL
- Field5 — datetime — NOT NULL
chats (채팅방목록)
- Field — int — Primary key — NOT NULL — auto_increment
- Field2 — string(255) — NOT NULL
- Field3 — boolean
- Field4 — datetime — NOT NULL
- Field5 — datetime — NOT NULL
comments (댓글)
- Key — int — Primary key — NOT NULL — auto_increment
- Key (Key2) — integer — Foreign key → msgs.Key
- Field — string(31) — NOT NULL
- Field2 — string — NOT NULL
- Field3 — datetime — NOT NULL
- Field4 — datetime — NOT NULL
groups (회사명.단체명)
- Key — int — Primary key — NOT NULL — auto_increment
- Field — string(31) — NOT NULL
- Field2 — string(31)
- Field3 — datetime — NOT NULL
- Field4 — datetime — NOT NULL
groupusers (그룹_사용자)
- Key — int — Primary key — NOT NULL — auto_increment
- Key (Key2) — integer — Foreign key → users.Key
- Key (Key3) — string(31) — Foreign key → groups.Key
- Field2 — datetime — NOT NULL
- Field3 — datetime — NOT NULL
msgs (채팅내용)
- Key — int — Primary key — NOT NULL — auto_increment
- Key (Key2) — integer — Foreign key → users.Key
- Key (Key3) — integer — Foreign key → chats.Field
- Field — string — NOT NULL
- Field2 — boolean
- Field3 — string(31)
- Field4 — datetime — NOT NULL
- Field5 — datetime — NOT NULL
userchats (사용자_채팅방목록)
- Key — int — Primary key — NOT NULL — auto_increment
- Key (Key2) — integer — Foreign key → users.Key
- Key (Key3) — integer — Foreign key → chats.Field
- Field — datetime — NOT NULL
- Field2 — datetime — NOT NULL
users (사용자)
- Key — int — Primary key — NOT NULL — auto_increment
- Field — string(31) — NOT NULL
- Field2 — string(31) — NOT NULL
- Field3 — string(31) — NOT NULL
- Field4 — string(31)
- Field5 — datetime — NOT NULL
- Field6 — datetime — NOT NULL