UMC_집다방 - 2023-05-04 12:00:57

테이블 (16)

Block_User (Untitled3)

  • id (block_user_id) — INT — 기본 키 — NOT NULL
  • Key (user_id2) — INT — 외래 키 — NOT NULL
  • Field3 (blocked_id) — INT
  • Field4 (create_time) — TIMESTAMP

FAQ (Untitled6)

  • FAQ_id (faq_id) — INT — 기본 키 — NOT NULL
  • Question_text (question_text) — TEXT
  • Answer_text (Field3)
  • quesion_user (user_id2) — INT — 외래 키 — NOT NULL
  • answer_user (user_id) — INT — 외래 키 — NOT NULL
  • create_date
  • expired_date
  • status

Notice (Untitled5)

  • Notice_id (notice_id) — 기본 키 — NOT NULL
  • Key (user_id) — INT — 외래 키 — NOT NULL
  • name — CARCHAR(100)
  • data (date) — TIMESTAMP
  • context — TEXT
  • uploader — INT
  • create_date
  • expired_date
  • status

Report (Untitled11)

  • Report_id — 기본 키 — NOT NULL
  • id (block_user_id) — INT — 외래 키 — NOT NULL
  • receipe_id — INT — 외래 키 — NOT NULL
  • from_user
  • context
  • create_date
  • status
  • updaet_date (update_date)
  • manager
  • report_info — INT
  • expired_date

Untitled2

    User (Untitled)

    • Key (user_id) — INT — 기본 키 — NOT NULL
    • Field (name)
    • Field2 (nickname)
    • Field3 (email)
    • Field4 (birthday)
    • Field5 (sex)
    • Field6 (service_ok)
    • 권한 동의 (Field)
    • Field2 (profile)
    • Field3 (status)
    • Field4 (create_day)
    • Field5 (update_day)
    • Field6 (admin)
    • Field2 (expired_day)

    User_like_beverage (Untitled4)

    • User_like_beverage_id (user_like_beverage_id) — 기본 키 — NOT NULL
    • Key (user_id) — INT — 외래 키 — NOT NULL
    • berage_id — varchar(45)
    • create_date
    • Field

    challenge (Untitled12)

    • challenge_id — 기본 키 — NOT NULL
    • receipe_id — INT — 외래 키 — NOT NULL
    • Key (user_id) — INT — 외래 키 — NOT NULL
    • chllenge_info (clahllenge_info)
    • create_date (cretae_date)
    • status
    • expired_datee (expired_date)

    comment (Untitled16)

    • comment_id — 기본 키 — NOT NULL
    • context (contex)
    • create_date
    • user_id — INT — 외래 키 — NOT NULL
    • receipe_id — INT — 외래 키 — NOT NULL
    • status — INT
    • expired_date

    ingredient (Untitled9)

    • ingredient_id — INT — 기본 키 — NOT NULL
    • receipe_id — INT — 외래 키 — NOT NULL
    • ingredient
    • count

    like (Untitled13)

    • like_id — 기본 키 — NOT NULL
    • Key (user_id2) — INT — 외래 키 — NOT NULL
    • receipe_id — INT — 외래 키 — NOT NULL
    • create_date

    myscrab (Untitled15)

    • myscrab_id (mysracb_id) — INT — 기본 키 — NOT NULL
    • scrab — INT
    • receipe_id — INT — 외래 키 — NOT NULL
    • Key (user_id) — INT — 외래 키 — NOT NULL
    • create_date
    • expired_date

    rank (Untitled14)

    • rank_id — 기본 키 — NOT NULL
    • user (user_id)
    • rank
    • Key (user_id2) — INT — 외래 키 — NOT NULL
    • receipe_id — INT — 외래 키 — NOT NULL
    • status
    • expired_date (xpired_date)
    • create_date

    receipe_made (Untitled10)

    • receipe_made_id — 기본 키 — NOT NULL
    • order
    • picture
    • context
    • receipe_id — INT — 외래 키 — NOT NULL

    recipe (Untitled8)

    • receipe_id — INT — 기본 키 — NOT NULL
    • Key (user_id) — INT — 외래 키 — NOT NULL
    • name (post_nmae) — VARCHAR(40)
    • beverage_name
    • introduce (intro) — TEXT
    • reveiw (review) — TEXT
    • jip (jin) — INT
    • post — INT
    • create_date — TIMESTAMP
    • update_date
    • made_time
    • views — INT
    • expried_date
    • status

    suply (Untitled7)

    • syply (syply_id) — INT — 기본 키 — NOT NULL
    • Context (context) — text
    • email
    • create_ date (create_date)
    • status
    • suply_user (user_id2) — INT — 외래 키 — NOT NULL
    • contact_persion (user_id) — INT — 외래 키 — NOT NULL
    • finish_date