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