umc-study
Tables (5)
food (Untitled2)
- food_id (id) — Primary key — NOT NULL
- name (음식이름) — varchar(20)
mem_mission (Untitled5)
- mamber_id (id) — bigint — Foreign key → member.mamber_id — NOT NULL
- mission_id (Key) — bigint — Foreign key → mission.mission_id — NOT NULL
member (Untitled)
- mamber_id (id) — bigint — Primary key — NOT NULL
- name (이름) — varchar(20) — NOT NULL
- gender (성별) — bit — NOT NULL
- address (주소) — text — NOT NULL
- create_at (설정시간) — datetime(6) — NOT NULL
- update_at (수정시간) — datetime(6) — NOT NULL
- status (상태) — varchar(15) — NOT NULL
- inactive_date (비활성화 시간) — datetime
- reward (리워드 포인트) — bigint
member_food (Untitled3)
- mem_food_id (id3) — bigint — Primary key — NOT NULL
- member_id (id) — bigint — Foreign key → member.mamber_id — NOT NULL
- food_id (id2) — Foreign key → food.food_id — NOT NULL
- Field
mission (Untitled4)
- mission_id (Key) — bigint — Primary key — NOT NULL
- name (이름) — varchar(10) — NOT NULL
- region (미션지역) — varchar(20) — NOT NULL