WailyEat 1.1

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)