SSwitch

Tables (18)

AED

  • id — bigint(20) — Primary key — NOT NULL
  • handle_id — bigint(20) — Foreign key → handle_report.id — NOT NULL
  • longitude — varchar(255) — NOT NULL
  • latitude — varchar(255) — NOT NULL
  • date_created — datetime — NOT NULL
  • date_modified — datetime — NOT NULL
  • detailed_location — varchar(255) — NOT NULL
  • AED_status — varchar(255) — NOT NULL

banner

  • id — bigint(20) — Primary key — NOT NULL
  • date_created — datetime — NOT NULL
  • image — varchar(20)
  • last_updated — datetime — NOT NULL
  • name — varchar(255) — NOT NULL
  • url — varchar(255) — NOT NULL
  • visible — bit(1) — NOT NULL

banner_click

  • id — bigint(20) — Primary key — NOT NULL
  • banner_id — bigint(20) — Foreign key → banner.id — NOT NULL
  • date_created — datetime — NOT NULL
  • click_count — int(11) — NOT NULL
  • ip — varchar(255) — NOT NULL

chatting

  • id — bigint(20) — Primary key — NOT NULL
  • room — varchar(255) — NOT NULL
  • date_created — datetime — NOT NULL

comment

  • id — bigint(20) — Primary key — NOT NULL
  • community_id — bigint(20) — Foreign key → forum.id — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • text — longtext — NOT NULL
  • date_created — datetime — NOT NULL
  • date_modified — datetime — NOT NULL

event(Optional) (event)

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • title — varchar(255) — NOT NULL
  • text — longtext — NOT NULL
  • date_created — datetime — NOT NULL
  • date_modified — datetime — NOT NULL

forum

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • title — varchar(255) — NOT NULL
  • text — longtext — NOT NULL
  • date_created — datetime — NOT NULL
  • date_modified — datetime — NOT NULL
  • like — bigint(10)
  • genre — varchar(255) — NOT NULL

goods

  • id — bigint(20) — Primary key — NOT NULL
  • goods_name — varchar(255) — NOT NULL
  • goods_text (goods_content) — text — NOT NULL
  • goods_point — bigint(20) — NOT NULL

handle_report

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • title — varchar(255)
  • text — varchar(255) — NOT NULL
  • handle_status (report_status) — bit(1) — NOT NULL

just_chatting

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • chatting_id — bigint(20) — Foreign key → chatting.id — NOT NULL
  • text — longtext — NOT NULL
  • date_created — datetime — NOT NULL

like_forum

  • id — bigint(20) — Primary key — NOT NULL
  • forum_id — bigint(20) — Foreign key → forum.id — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL

non_smoking

  • id — bigint(20) — Primary key — NOT NULL
  • handle_id — bigint(20) — Foreign key → handle_report.id — NOT NULL
  • longitude — varchar(255) — NOT NULL
  • latitude — varchar(255) — NOT NULL
  • date_created — datetime — NOT NULL
  • date_modified — datetime — NOT NULL
  • smoking_status — bit(1) — NOT NULL

notice

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • title — varchar(255) — NOT NULL
  • text — longtext — NOT NULL
  • date_created — datetime — NOT NULL
  • date_modified — datetime — NOT NULL

order

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • date_created — datetime — NOT NULL
  • date_modified — datetime — NOT NULL
  • order_status — bit(1) — NOT NULL

order_goods

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • goods_id — bigint(20) — Foreign key → goods.id — NOT NULL
  • order_id — bigint(20) — Foreign key → order.id — NOT NULL
  • event_id (id2) — bigint(20) — Foreign key → event(Optional).id

report (Untitled13)

  • id — bigint(20) — Primary key — NOT NULL
  • handle_id — bigint(20) — Foreign key → handle_report.id — NOT NULL
  • order_goods_id — bigint(20) — Foreign key → order_goods.id — NOT NULL
  • title — varchar(255) — NOT NULL
  • text — varchar(255) — NOT NULL
  • date_created — datetime — NOT NULL
  • shingo_status — bit(1) — NOT NULL

trash_can

  • id — bigint(20) — Primary key — NOT NULL
  • handle_id — bigint(20) — Foreign key → handle_report.id — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • longitude — varchar(255) — NOT NULL
  • latitude — varchar(255) — NOT NULL
  • date_created — datetime — NOT NULL
  • date_modified — datetime — NOT NULL
  • trash_status — varchar(255) — NOT NULL

user

  • id — bigint(20) — Primary key — NOT NULL
  • login_id — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • user_name — varchar(255)
  • email — varchar(255) — NOT NULL
  • point — bigint(20) — NOT NULL
  • point_all — bigint(20) — NOT NULL
  • date_created — datetime — NOT NULL
  • role — varchar(255) — NOT NULL
  • providers — varchar(255) — NOT NULL
  • user_status — varchar(255) — NOT NULL