tsnp market
Tables (6)
faq
- id — VARCHAR(191) — Primary key — NOT NULL
- faq_question — VARCHAR(191) — NOT NULL
- faq_answer — TEXT — NOT NULL
- faq_category — VARCHAR(191) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
item
- id — VARCHAR(191) — Primary key — NOT NULL
- item_title — VARCHAR(191) — NOT NULL
- item_price — VARCHAR(191) — NOT NULL
- item_progress — INTEGER — NOT NULL
- item_img_path — VARCHAR(191) — NOT NULL
- item_category — VARCHAR(191) — NOT NULL
- user_password — VARCHAR(191) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
like
- id — INTEGER — Primary key — NOT NULL
- user_id — VARCHAR(191) — Foreign key → user.id — NOT NULL
- item_id — VARCHAR(191) — Foreign key → item.id — NOT NULL
notice
- notice_id — VARCHAR(191) — Primary key — NOT NULL
- user_id — VARCHAR(191) — Foreign key → user.id — NOT NULL
- notice_title — VARCHAR(191) — NOT NULL
- notice_contents — TEXT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
order
- id — VARCHAR(191) — Primary key — NOT NULL
- user_id — VARCHAR(191) — Foreign key → user.id — NOT NULL
- item_id — VARCHAR(191) — Foreign key → item.id — NOT NULL
- completed — BOOLEAN — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
user
- id — VARCHAR(191) — Primary key — NOT NULL
- user_email — VARCHAR(191) — NOT NULL
- user_name — VARCHAR(191) — NOT NULL
- user_type — VARCHAR(191) — NOT NULL
- user_password — VARCHAR(191) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL