WailyEat 1.0
WailyEat cms project
Tables (21)
account (계정정보)
- id (Key) — Primary key — NOT NULL
- auth (Field2)
- name (이름) — varchar(50)
- birth (생년월일)
- gender (성별)
- tel (연락처)
- email (이메일)
- password (패스워드)
- diet_check (식단관리유무)
- height (신장)
- weight (몸무게)
- dest_weight (목표 몸무게)
- dest_date (목표 날짜)
- activity_level (활동 수준)
- diet_purpose (식단관리 목적)
- diet_precaution (식단 유의사항)
- created_date (가입 일자)
- status (상태) — 탈퇴
- point (Field)
- id (attached_file) — Foreign key → attached_file.id — NOT NULL
attached_file (첨부파일)
- id (Key) — Primary key — NOT NULL
- attached_file1_name (Field)
- attached_file_src (Field2)
- file_size (Field3)
- file_path (Field4)
board (보드)
- id (Key) — Primary key — NOT NULL
- title (Field2)
- content (Field7)
- writer (Field5)
- created_date (Field3)
- updated_date (Field9)
- like_cnt (Field4)
- score (Field11)
- count (Field12)
- secret_yn (Field10)
- use_yn (Field8)
- id (Key2) — Foreign key → board_info.id — NOT NULL
- id (Key4) — Foreign key → category.id — NOT NULL
board_info (보드마스터)
- id (Key) — Primary key — NOT NULL
- name (Field)
borad_tag (보드_태그)
- id (Key) — Primary key — NOT NULL
- id (Key3) — Foreign key → board.id — NOT NULL
- id (Key2) — Foreign key → tag.id — NOT NULL
category (카테고리)
- id (Key) — Primary key — NOT NULL
- name (카테고리명)
- id (Key2) — Foreign key → board_info.id — NOT NULL
comment (댓글)
- id (Key) — Primary key — NOT NULL
- title (Field)
- content (Field2)
- created_date (Field3)
- updated_date (Field4)
- use_yn (Field5)
- id (Key2) — Foreign key → board.id — NOT NULL
- id (Key3) — Foreign key → account.id — NOT NULL
- id (Key22) — Foreign key — NOT NULL
coupon (쿠폰)
- id (Key) — Primary key — NOT NULL
- period (Field)
- title (Field2)
- sub_title (Field3)
- discount_rate (Field4)
- created_date (Field5)
custom_diet (맞춤식단)
- id (Key) — Primary key — NOT NULL
- order_num (주문번호)
- diet_type (식단 형태)
- diet_purpose (식단 목적)
- diet_precaution (식단 유의사항)
- diet_quantity (주당 식단 수)
- diet_week (배송 요일)
- diet_period (관리 기간)
- order_date (주문날짜)
- name (받는사람)
- address (받는주소)
- tel (연락처)
- memo (요구사항)
- id (account) — Foreign key → account.id — NOT NULL
custom_diet_config (맞춤식단_ 설정)
- id (Key) — Primary key — NOT NULL
- name (Field)
- type (Field2) — 구분자 |
delivery (배송 (회차관리))
- id (Key) — Primary key — NOT NULL
- round (Field2)
- status (Field)
- cancel_memo (Field3)
- cancelled_date (Field4)
- id (Key2) — Foreign key → custom_diet.id — NOT NULL
delivery_item
- id (Key2) — Primary key — NOT NULL
- id (Key3) — Foreign key → items.id — NOT NULL
- id (Key) — Foreign key → delivery.id — NOT NULL
diary (다이어리)
- id (Key2) — Primary key — NOT NULL
- id (account) — Foreign key → account.id — NOT NULL
- date (Field)
- weight (Field5)
- muscle_rate (Field6)
- fat_rate (Field7)
diary_food
- id (Key) — Primary key — NOT NULL
- id (Key3) — Foreign key → food.id — NOT NULL
- id (Key2) — Foreign key → diary.id — NOT NULL
- type (Field) — 아침점심저녁
food (음식카테고리)
- id (Key) — Primary key — NOT NULL
- name (Field18)
- weight (Field2) — g
- kcal (Field3) — kcal
- carbohydrate (Field4)
- protein (Field5)
- fat (Field6)
- natrium (Field7) — mg
- sugar (Field8)
- saturated _fatty_acid (Field9)
- trans_fat (Field10) — mg
- cholesterol (Field11) — mg
- calcium (Field12) — mg
- Iron (Field13) — mg
- potassium (Field14) — mg
- dietary_fiber (Field15)
- vitamin_c (Field16) — mg
- type (Field17) — user_custom_food admin_custom_food api
- ref (Field)
- created_date (Field19)
- id (Key2) — Foreign key → account.id — NOT NULL — 등록자
items (상품)
- id (Key) — Primary key — NOT NULL
- name (Field12)
- material (Field11)
- description (Field10)
- weight (Field9)
- supplier (Field8)
- caloriez (Field)
- price (Field2)
- status (Field4)
- diet_type (Field5)
- diet_purpose (Field6)
- diet_precaution (Field7)
- id (attached_file) — Foreign key → attached_file.id — NOT NULL
multi_attach (board_attached_file)
- Key3 (id) — Primary key — NOT NULL
- id (Key) — Foreign key → board.id — NOT NULL
- id (Key2) — Foreign key → attached_file.id — NOT NULL
tag (태그)
- id (Key) — Primary key — NOT NULL
- name (Field)
- count (Field2)
- id (Key2) — Foreign key → board_info.id — NOT NULL
user_card (카드정보)
- Key2 — Primary key — NOT NULL
- id (Key) — Foreign key → account.id — NOT NULL
- card_num (Field)
- due_date (Field2)
- cvc (Field3)
- created_date (Field4)
user_coupon (사용자 쿠폰)
- id (Key) — Primary key — NOT NULL
- Field
- due_date (Field2)
- down_ck (Field3)
- id (Key2) — Foreign key → account.id — NOT NULL
- id (Key3) — Foreign key → coupon.id — NOT NULL
user_point (포인트)
- id (Key) — Primary key — NOT NULL
- id (Key2) — Foreign key → account.id — NOT NULL
- point
- type
- created_date (Field)
- name (Field2)