market
Tables (10)
category
- id — VARCHAR(30) — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
like
- userid — VARCHAR(30) — Foreign key → user.id — NOT NULL
- productid — VARCHAR(30) — Foreign key → product.id — NOT NULL
- created_at — now()
notice
- id — VARCHAR(30) — Primary key — NOT NULL
- title — VARCHAR(30) — NOT NULL
- content — text — NOT NULL
- category — VARCHAR(30) — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
order
- id — VARCHAR(30) — Primary key — NOT NULL
- userid — VARCHAR(30) — Foreign key → user.id — NOT NULL
- productid — VARCHAR(30) — Foreign key → product.id — NOT NULL
- number_of_purchases — int — NOT NULL
- status — int — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
ownership
- userid — VARCHAR(30) — Foreign key → user.id — NOT NULL
- productid — VARCHAR(30) — Foreign key → product.id — NOT NULL
- created_at — DATETIME — NOT NULL
partner
- id — VARCHAR(30) — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
product
- id — VARCHAR(30) — Primary key — NOT NULL
- categoryid — VARCHAR(30) — Foreign key → category.id — NOT NULL
- title — VARCHAR(30) — NOT NULL
- content — text — NOT NULL
- like_count — int — NOT NULL
- is_delete — boolean — NOT NULL
- total — int — NOT NULL
- price — int — NOT NULL
- stock — int — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
product_image
- id — VARCHAR(30) — Primary key — NOT NULL
- productid — VARCHAR(30) — Foreign key → product.id — NOT NULL
- image_path — VARCHAR(30) — NOT NULL
- sequence — int — NOT NULL
- created_at — DATETIME — NOT NULL
review
- id — VARCHAR(30) — Primary key — NOT NULL
- userid — VARCHAR(30) — Foreign key → user.id — NOT NULL
- productid — VARCHAR(30) — Foreign key → product.id — NOT NULL
- title — VARCHAR(30) — NOT NULL
- content — text — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
user
- id — VARCHAR(30) — Primary key — NOT NULL
- partnerid — VARCHAR(30) — Foreign key → partner.id — NOT NULL
- email — VARCHAR(30) — NOT NULL
- password — VARCHAR(30) — NOT NULL
- image_path — VARCHAR(30)
- name — VARCHAR(30) — NOT NULL
- tel — VARCHAR(30) — NOT NULL
- nickname — VARCHAR(30)
- type — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL