0314

Tables (7)

Favorite

  • favorite_id — INT — NOT NULL
  • member_id — INT — NOT NULL
  • prd_id — INT — NOT NULL

Member

  • member_id — INT — Primary key — NOT NULL — Primary Key
  • email — VARCHAR(200) — NOT NULL — 소셜/일반 로그인 이메일
  • password — VARCHAR(200) — 소셜 로그인 사용자는 NULL
  • nickname — VARCHAR(50) — NOT NULL
  • gender — ENUM('MALE', 'FEMALE') — NOT NULL
  • birth — DATE — NOT NULL
  • member_role — ENUM('USER', 'ADMIN') — NOT NULL
  • social_type — ENUM('NONE', 'KAKAO', 'NAVER', 'GOOGLE') — 소셜 로그인 구분

Member_Social

  • social_id — INT — NOT NULL — 소셜 로그인 고유 ID
  • member_id — INT — NOT NULL — Member 테이블 참조
  • social_type — ENUM('KAKAO', 'NAVER', 'GOOGLE') — NOT NULL — 소셜 로그인 유형

Notice

  • notice_id — INT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • member_id — INT — NOT NULL

Product

  • prd_id — INT — NOT NULL
  • product_name — VARCHAR(50) — NOT NULL
  • company_name — VARCHAR(50)
  • registration_no — VARCHAR(200)
  • expiration_period — VARCHAR(50)
  • srv_use — TEXT
  • main_function — TEXT
  • preservation — TEXT
  • intake_hint — TEXT
  • base_standard — TEXT

Review

  • review_id — INT — NOT NULL
  • rating — ENUM('좋아요', '싫어요')
  • content — TEXT
  • image — VARCHAR(200)
  • member_id — INT — NOT NULL
  • prd_id — INT — NOT NULL

Schedule

  • schedule_id — INT — NOT NULL
  • intake_start — DATE — NOT NULL
  • intake_distance — VARCHAR(200)
  • intake_end — DATE
  • memo — TEXT
  • member_id — INT — NOT NULL
  • prd_id — INT — NOT NULL