handicine
Tables (7)
Answers
- answer_id — INT AUTO_INCREMENT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- user_id — INT AUTO_INCREMENT — Foreign key → Users.user_id — NOT NULL
- question_id — INT AUTO_INCREMENT — Foreign key → Questions.question_id — NOT NULL
Comments
- comment_id — INT AUTO_INCREMENT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- user_id — INT AUTO_INCREMENT — Foreign key → Users.user_id — NOT NULL
- post_id — INT AUTO_INCREMENT — Foreign key → Posts.post_id — NOT NULL
Medicine
- user_id — INT AUTO_INCREMENT — Primary key — NOT NULL
- atpn_qesitm — VARCHAR(1000)
- deposit_method_qesitm — VARCHAR(255)
- efcy_qesitm — VARCHAR(255)
- entp_name — VARCHAR(255)
- intrc_qesitm — VARCHAR(255)
- item_image — VARCHAR(255)
- item_name — VARCHAR(255)
- se_qesitm — VARCHAR(1000)
- use_method_qesitm — VARCHAR(255)
Posts
- post_id — INT AUTO_INCREMENT — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- user_id — INT AUTO_INCREMENT — Foreign key → Users.user_id — NOT NULL
Questions
- question_id — INT AUTO_INCREMENT — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- user_id — INT AUTO_INCREMENT — Foreign key → Users.user_id — NOT NULL
Roles
- role_id — INT AUTO_INCREMENT — Primary key — NOT NULL
- role_name — VARCHAR(50) — NOT NULL
Users
- user_id — INT AUTO_INCREMENT — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- role_id — INT AUTO_INCREMENT — Foreign key → Roles.role_id — NOT NULL