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