SSwitch MYSQL

Tables (10)

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • date_created — DATETIME
  • date_modified — DATETIME
  • comment_text — TEXT — NOT NULL
  • forum_id — BIGINT — Foreign key → forum.forum_id
  • user_id — BIGINT — Foreign key → user.user_id

event

  • event_id — BIGINT — Primary key — NOT NULL
  • date_created — DATETIME
  • date_modified — DATETIME
  • event_text — TEXT — NOT NULL
  • event_title — VARCHAR(255) — NOT NULL
  • image_path — VARCHAR(255)
  • user_id — BIGINT — Foreign key → user.user_id

forum

  • forum_id — BIGINT — Primary key — NOT NULL
  • date_created — DATETIME
  • date_modified — DATETIME
  • ddabong — INT — NOT NULL
  • forum_like — BIGINT — NOT NULL
  • forum_text — TEXT — NOT NULL
  • forum_title — TEXT — NOT NULL
  • secret — VARCHAR(255)
  • tag — TEXT — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id

goods

  • goods_id — BIGINT — Primary key — NOT NULL
  • goods_image — VARCHAR(255)
  • goods_name — VARCHAR(100) — NOT NULL
  • goods_status — VARCHAR(255) — NOT NULL
  • goods_text — TEXT — NOT NULL
  • price — INT — NOT NULL

like_forum

  • like_forum_id — BIGINT — Primary key — NOT NULL
  • date_created — DATETIME
  • date_modified — DATETIME
  • like_forum_num — BIGINT
  • forum_id — BIGINT — Foreign key → forum.forum_id
  • user_id — BIGINT — Foreign key → user.user_id

notice

  • notice_id — BIGINT — Primary key — NOT NULL
  • date_created — DATETIME
  • date_modified — DATETIME
  • notice_text — TEXT — NOT NULL
  • notice_title — VARCHAR(255) — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id

order_goods

  • order_goods_id — BIGINT — Primary key — NOT NULL
  • date_created — DATETIME
  • date_modified — DATETIME
  • gift_code — VARCHAR(255)
  • quantity — INT — NOT NULL
  • goods_id — BIGINT — Foreign key → goods.goods_id
  • order_id — BIGINT — Foreign key → orders.order_id
  • user_id — BIGINT — Foreign key → user.user_id

orders

  • order_id — BIGINT — Primary key — NOT NULL
  • date_created — DATETIME
  • date_modified — DATETIME
  • user_name — VARCHAR(255)
  • user_id — BIGINT — Foreign key → user.user_id
  • goods_name — VARCHAR(255)
  • total_price — INT — NOT NULL

trashcan

  • trash_id — BIGINT — Primary key — NOT NULL
  • date_created — DATETIME
  • date_modified — DATETIME
  • latitude — VARCHAR(255) — NOT NULL
  • longitude — VARCHAR(255) — NOT NULL
  • trash_status — VARCHAR(255) — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id
  • address — VARCHAR(255) — NOT NULL

user

  • user_id — BIGINT — Primary key — NOT NULL
  • date_created — DATETIME
  • date_modified — DATETIME
  • current_points — INT — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • enabled — BIT(1) — NOT NULL
  • login_id — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • profile_image — VARCHAR(255)
  • providers — VARCHAR(255) — NOT NULL
  • role — VARCHAR(255) — NOT NULL
  • total_points — INT — NOT NULL
  • user_name — VARCHAR(255) — NOT NULL
  • status — VARCHAR(255) — NOT NULL