spaghetti_listener
Tables (4)
answers (답변 테이블)
- id (답변번호) — NUMBER — Primary key — NOT NULL
- user_id (유저번호) — NUMBER — Foreign key → users.id
- quesetion_id (질문번호) — NUMBER — Foreign key → questions.id
- content (답변내용) — TEXT
- good (추천) — NUMBER
- bad (비추천) — NUMBER
- selection (채택여부) — NUMBER
images (사진 테이블)
- id (사진번호) — NUMBER — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- question_id (질문번호) — NUMBER — Foreign key → questions.id
- url (사진 url) — VARCHAR
questions (질문 테이블)
- id (질문번호) — NUMBER — Primary key
- user_id (유저번호) — NUMBER — Foreign key → users.id
- title (질문제목) — VARCHAR
- content (질문내용) — TEXT
- views (조회수) — NUMBER
- goods (추천) — NUMBER
- bads (비추천) — NUMBER
- category (카테고리) — VARCHAR(30)
users (유저 테이블)
- id (유저번호) — NUMBER — Primary key
- email (이메일) — VARCHAR(50)
- password (비밀번호) — VARCHAR(80)
- nick (닉네임) — VARCHAR100)
- profile_img (프로필사진 url) — VARCHAR(255)
- introduce (자기소개) — VARCHAR(100)
- role (권한) — VARCHAR(20)
- point (포인트) — NUMBER