CRM
Tables (4)
Account (Account_table)
- Account ID (Account_ID) — VARCHAR — Primary key — NOT NULL
- Name (NAME) — VARCHAR(225)
- Address (ADDRESS) — VARCHAR
- About (ABOUT) — VARCHAR
- Archive (ARCHIVED_AT) — DATETIME
- Create Time (CREATED_AT) — DATETIME
- Latitude (lat) — VARCHAR
- Longitude (lon) — VARCHAR
Admin (ADMIN_TABLE)
- Admin ID (ADMIN_ID) — VARCHAR — Primary key — NOT NULL
- Name (NAMEN) — VARCHAR(225)
- Email (EMAIL) — VARCHAR
- Archive (ARCHIVED_AT) — DATETIME
- Create Time (CREATED_AT) — DATETIME
Note (NOTE_TABLE)
- Note ID (NOTE_ID) — VARCHAR — Primary key — NOT NULL
- Account ID (Account_ID) — VARCHAR — Foreign key → Account.Account ID — NOT NULL
- Admin ID (ADMIN_ID2) — VARCHAR — Foreign key → Admin.Admin ID — NOT NULL
- Content (CONTENT) — VARCHAR
- Create Time (CREATED_AT) — DATETIME
Tag (TAG_TABLE)
- Tag ID (TAG_ID) — VARCHAR — Primary key — NOT NULL
- Account ID (account_id) — VARCHAR — Foreign key → Account.Account ID — NOT NULL
- Admin ID (ADMIN_ID) — VARCHAR — Foreign key → Admin.Admin ID — NOT NULL
- Type of the tag (tag_type) — VARCHAR(225)
- Value of the type (tag_value) — VARCHAR(225)