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)