SellingCommunity
Tables (6)
comment (Untitled4)
- comment_id (Key) — VARCHAR(255) — Primary key — NOT NULL
- post_id (Key2) — VARCHAR(255) — Foreign key → communityPost.post_id — NOT NULL
- user_id (Key3) — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
- content (Field) — TEXT — NOT NULL
communityPost (Untitled2)
- post_id (Key) — VARCHAR(255) — Primary key — NOT NULL
- user_id (Key2) — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
- title (Field) — VARCHAR(100) — NOT NULL
- content (Field2) — TEXT — NOT NULL
- image (Field3) — VARCHAR(255)
like (Untitled5)
- like_id (Key) — VARCHAR(255) — Primary key — NOT NULL
- user_id (Key2) — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
- post_id (Key3) — VARCHAR(255) — Foreign key → communityPost.post_id — NOT NULL
- like_time (Field) — DATETIME — NOT NULL
purchase (Untitled6)
- puchase_id (Key) — VARCHAR(255) — Primary key — NOT NULL
- user_id (Key2) — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
- sale_id (Key3) — VARCHAR(255) — Foreign key → selling_board.sale_id — NOT NULL
- purchae_date (Field) — DATETIME — NOT NULL
- quantity (Field2) — INT — NOT NULL
selling_board (Untitled3)
- sale_id (Key) — VARCHAR(255) — Primary key — NOT NULL
- user_id (Key2) — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
- user_id (Field2) — VARCHAR(255) — NOT NULL
- title (Field3) — VARCHAR(255) — NOT NULL
- content (Field4) — TEXT — NOT NULL
- image (Field) — VARCHAR(255)
user (Untitled)
- user_id (Key) — VARCHAR(255) — Primary key — NOT NULL
- username (Field) — VARCHAR(30) — NOT NULL
- password (Field2) — VARCHAR(100) — NOT NULL
- name (Field3) — VARCHAR(50) — NOT NULL
- age (Field4) — INT — NOT NULL
- address (Field5) — NOT NULL