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