cantata
Tables (5)
categories
- pk — INT — Primary key
- category_number — INT — NOT NULL
- main_category — VARCHAR(100) — NOT NULL
- sub_category — VARCHAR(100)
categories_give
- pk — INT — Primary key
- pk (pk2) — INT — Foreign key → users.pk
- category_number — INT — NOT NULL
- main_category — VARCHAR(100) — NOT NULL
- sub_category — VARCHAR(100)
- user_id — INT — NOT NULL
- registration_date — DATETIME
categories_take
- pk (pk2) — INT — Foreign key → users.pk
- pk — INT
- category_number — INT — NOT NULL
- main_category — VARCHAR(100) — NOT NULL
- sub_category — VARCHAR(100)
- user_id — INT — NOT NULL
- registration_date — DATETIME
user_talent_match
- pk — INT — Primary key
- user1_id — INT — NOT NULL
- user2_id — INT — NOT NULL
- user1_talent — VARCHAR(255) — NOT NULL
- user2_talent — VARCHAR(255) — NOT NULL
- match_time — DATETIME
users
- pk — INT — Primary key
- id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- birth_date — DATE
- gender — CHAR(1)
- registration_date — DATETIME
- deactivation_date — DATETIME