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