a
Tables (13)
Calendar
- id — bingint — Primary key — NOT NULL
- user_id — bingint — Foreign key → Users.id — NOT NULL
- start_date — DAYTIME
- end_date — DATATIME
- content — varchar(100)
- created_at — DAYTIME
ChatBot
- id — bigint — Primary key — NOT NULL
- user_id — bingint — Foreign key → Users.id — NOT NULL
- title — varchar(255)
- created_at — DAYTIME
ChatBotmessage
- id — bigint — Primary key — NOT NULL
- session_id — bigint — Foreign key → ChatBot.id — NOT NULL
- user_id — bingint — Foreign key → ChatBot.user_id — NOT NULL
- sender_type — enum
- message — varchar(255)
- created_at — DAYTIME
ChatMessages
- id — bigint — Primary key — NOT NULL
- chatroom_id — bigint — Foreign key → ChatRoomUsers.chatroom_id — NOT NULL
- user_id — bingint — Foreign key → Users.id — NOT NULL
- created_at — DAYTIME
- is_read — BOOLEAN
- message — varchar(255)
ChatRoomUsers
- id — bigint — Primary key — NOT NULL
- chatroom_id — bigint — Foreign key → Chatrooms.id — NOT NULL
- user_id — bigint — Foreign key → Users.id — NOT NULL
- created_at — DAYTIME
Chatrooms
- id — bigint — Primary key — NOT NULL
- room_name — varchat(20)
- created_at — DAYTIME
Comments
- id — bigint — Primary key — NOT NULL
- post_id — bigint — Foreign key → Posts.id — NOT NULL
- user_id2 — bigint — Foreign key → Posts.user_id — NOT NULL
- content — varchar(500)
- created_at — DAYTIME
- Field — VARCHAR(255)
Posts
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → Users.id — NOT NULL
- title — varchar(100)
- content — varchar(500)
- count — bigint
- rating — float
- created_at — DATETIME
ProductReviews
- id — bigint — Primary key — NOT NULL
- product_id — bingint — Foreign key → Users.id — NOT NULL
- user_id — bigint — Foreign key → Shop.id — NOT NULL
- rating — float
- title — varchar(500)
- content — varchar(500)
- created_at — VARCHAR(255)
ProductTag
- id — bigint — Primary key — NOT NULL
- product_id — bigint — Foreign key → Shop.id — NOT NULL
- tag_name — varchar(300)
Shop
- id — bigint — Primary key — NOT NULL
- item_title — varchar(20)
- price — bigintt
- item_url — varchaar(255)
- created_at — DAYTIME
- content — varchar(500)
- tag_name — VARCHAR(255)
- Field — VARCHAR(255)
Users
- id — bingint — Primary key — NOT NULL
- name — varchar(10)
- email — varchar(50)
- log_id — varchar(30)
- pwd_hash — varchar(255)
- profile_img — varchar(255)
- created_at — DAYTIME
- Field — VARCHAR(255)