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