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
- create_ date (create_date)
- status
- suply_user (user_id2) — INT — 외래 키 — NOT NULL
- contact_persion (user_id) — INT — 외래 키 — NOT NULL
- finish_date