DB_Class
Tables (9)
Address
- id — bigint — Primary key — NOT NULL
- province — varchar(30) — NOT NULL
- city — varchar(30) — NOT NULL
- district — varchar(30) — NOT NULL
Comment
- id — bigint — Primary key — NOT NULL
- userId — varchar(255) — Foreign key → User.id — NOT NULL
- postId — bigint — Foreign key → Community_Post.id
- saleId — bigint — Foreign key → Sales_Post.id
- parentId — bigint — Foreign key → Comment.id
- content — varchar(255) — NOT NULL
- create_at — TIMESTAMP — NOT NULL
Community_Post
- id — bigint — Primary key — NOT NULL
- userId — varchar(255) — Foreign key → User.id — NOT NULL
- title — varchar(255) — NOT NULL
- content — TEXT — NOT NULL
- photo — varchar(255) — NOT NULL
- create_at — TIMESTAMP — NOT NULL
- hashId — bigint
Follow
- follower_id — varchar(255) — Foreign key → User.id — NOT NULL
- following_id — varchar(255) — Foreign key → User.id — NOT NULL
Like
- id — bigint — Primary key — NOT NULL
- userId — varchar(255) — Foreign key → User.id — NOT NULL
- postId — bigint — Foreign key → Community_Post.id — NOT NULL
Purchase
- id — bigint — Primary key — NOT NULL
- userId — varchar(255) — Foreign key → User.id — NOT NULL
- saleId — bigint — Foreign key → Sales_Post.id — NOT NULL
- purchase_date — TIMESTAMP — NOT NULL
- quantity — bigint — NOT NULL
Sales_Post
- id — bigint — Primary key — NOT NULL
- userId — varchar(255) — Foreign key → User.id — NOT NULL
- title — varchar(255) — NOT NULL
- content — TEXT — NOT NULL
- photo — varchar(255) — NOT NULL
- price — bigint — NOT NULL
- create_at — TIMESTAMP — NOT NULL
User
- id — varchar(255) — Primary key — NOT NULL
- addressId — bigint — NOT NULL
- login_id — varchar(50) — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(50) — NOT NULL
- age — int
- dtail_address — varchar(255) — NOT NULL
hashtag
- id — bigint — Primary key — NOT NULL
- hash — varchar(255) — NOT NULL