COMMA
Tables (10)
Account
- id (account_id) — varchar — Primary key — NOT NULL
- Field (email) — varchar — NOT NULL
- Field (password) — varchar — NOT NULL
- Field (name) — varchar — NOT NULL
- Field (major) — varchar — NOT NULL
- Field (academic_status) — varchar — NOT NULL
- Field (academic_number) — int — NOT NULL
- Field (role) — varchar — NOT NULL
- Field (created_date) — localdatetime — NOT NULL
- Field (last_modified_date) — localdatetime — NOT NULL
Untitled (Arduino_item)
- Key (arduino_item_id) — int — Primary key — NOT NULL
- Field (name) — varchar — NOT NULL
- Field (count) — int — NOT NULL
- Field (original_count) — int — NOT NULL
- Field (description) — text — NOT NULL
- Field (created_date) — localdatetime — NOT NULL
- Field (last_modified_date) — localdatetime — NOT NULL
Untitled (arduino_order)
- Key (Arduino_order_id) — int — Primary key — NOT NULL
- Field (order_number) — varchar — NOT NULL
- id (account_id) — varchar — Foreign key → Account.id — NOT NULL
- Key (arduino_item_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (subject_name) — varchar — NOT NULL
- Field (count) — int — NOT NULL
- Field (application_status) — varchar — NOT NULL
- Field (created_date) — localdatetime — NOT NULL
- Field (last_modified_date) — localdatetime — NOT NULL
Untitled (Arduino_item_comment)
- Key (Arduino_item_comment_id) — int — Primary key — NOT NULL
- id (account_id) — varchar — Foreign key → Account.id — NOT NULL
- Key (arduino_item_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (content) — text — NOT NULL
- Field (created_date) — localdatetime — NOT NULL
- Field (last_modified_date) — localdatetime — NOT NULL
- Field (content_status) — varchar — NOT NULL
Untitled (Arduino_order_description)
- Key (Arduino_order_description_id) — int — Primary key — NOT NULL
- Field (description) — text — NOT NULL
- Field (order_number) — varchar — NOT NULL
Untitled (arduino_category)
- Key (arduino_category_id) — int — Primary key — NOT NULL
- Field (name) — varchar — NOT NULL
Untitled (arduino_item_category)
- Key (arduino_item_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (arduino_category_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (arduino_like)
- id (account_id) — varchar — Foreign key → Account.id — NOT NULL
- Key (arduino_item_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Account_email_verify)
- Key (auth_email) — varchar — Primary key — NOT NULL
- Field (verified) — boolean — NOT NULL
- Field (code) — int — NOT NULL
- Field (created_date) — localdatetime — NOT NULL
- Field (last_modified_date) — localdatetime — NOT NULL
Untitled (arduino_basket)
- Key (arduino_basket_id) — int — Primary key — NOT NULL
- id (account_id) — varchar — Foreign key → Account.id — NOT NULL
- Key (arduino_item_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (count) — int — NOT NULL