TodayErd
Tables (23)
CopyOfUntitled16
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255) — donation, goods
- Field2 — VARCHAR(255) — 3, 13, 53
- Field3 — VARCHAR(255)
CopyOfUntitled2
- Key — int — Primary key — NOT NULL
- Field — varchar
- Field2 — varchar
- Field3 — int
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
CopyOfUntitled3
- Key3 — uuid — Foreign key → Untitled2.Key — NOT NULL
- Key2 — int — Foreign key → CopyOfUntitled2.Key — NOT NULL
- Field11 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field9 — VARCHAR(255)
- Field10 — VARCHAR(255) — s43242, p48324, p21475
- Field — VARCHAR(255)
- Field3 — VARCHAR(255)
USER_DEVICE_TOKEN
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
USER_ROLE
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
Untitled
- Key — int — Primary key — NOT NULL
- Field8 — varchar — popup, sliding
- Field — varchar
- Field2 — varchar
- Field14 — VARCHAR(255) — Only sliding
- Field16 — VARCHAR(255) — Only sliding
- Field15 — VARCHAR(255) — Only sliding
- Field17 — VARCHAR(255) — Only sliding
- Field11 — VARCHAR(255) — url, image, app_page, no_link
- Field5 — VARCHAR(255)
- Field12 — VARCHAR(255)
- Field13 — VARCHAR(255) — home, my_usage, point
- Field6 — DateTime
- Field7 — DateTime
- Field9 — VARCHAR(255) — activated, paused, finished, deleted
- Field10 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
Untitled10
- Key — VARCHAR(255) — Primary key — NOT NULL
- Key2 — uuid — Foreign key → Untitled2.Key — NOT NULL
- Key3 — VARCHAR(255) — Foreign key → Untitled19.Key — NOT NULL
- Field2 — VARCHAR(255) — rewards, expired
- Field4 — VARCHAR(255)
- Field3 — VARCHAR(255) — shipped, cancelled, ordered
- Field5 — VARCHAR(255)
- Field — VARCHAR(255)
Untitled11
- Key — VARCHAR(255) — Primary key — NOT NULL
Untitled12
- Key — VARCHAR(255) — Primary key — NOT NULL
- Key2 — VARCHAR(255) — Foreign key → Untitled15.Key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field7 — VARCHAR(255)
- Field6 — VARCHAR(255)
Untitled13
- Key2 — uuid — Foreign key → Untitled2.Key — NOT NULL
- Field2 — VARCHAR(255) — webin_p + webincam_p + event_points+ cs_given_points
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field3 — VARCHAR(255) — 쓰레기 버린거 제외하고 얻은 포인트
- Field11 — VARCHAR(255)
- Field — VARCHAR(255) — donated_points + purchasing_points + expired_points
- Field10 — VARCHAR(255) — 기부 포인트
- Field12 — VARCHAR(255) — goods 구입 포인트
- Field9 — VARCHAR(255)
- Field4 — VARCHAR(255) — earned_points - used_points
- Field7 — dateTime
- Field8 — dateTime
Untitled14
- Key — VARCHAR(255) — Primary key — NOT NULL
- Key3 — uuid — Foreign key → Untitled2.Key — NOT NULL
- Key2 — VARCHAR(255) — Foreign key → Untitled5.Key — NOT NULL
- Key42 — VARCHAR(255) — Foreign key → Untitled5.Key4 — NOT NULL
- Key4 — VARCHAR(255) — Foreign key → Untitled11.Key — NOT NULL
- Field2 — VARCHAR(255) — FK
- Field3 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field9 — VARCHAR(255)
- Field10 — VARCHAR(255)
- Field8 — VARCHAR(255)
- Field12 — VARCHAR(255)
Untitled15
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255) — Which functions in console they can access
Untitled16
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255) — popup, sliding
- Field2 — VARCHAR(255) — 3, 13, 53
- Field3 — VARCHAR(255)
Untitled18
- Key — VARCHAR(255) — Primary key — NOT NULL
- Key2 — VARCHAR(255) — Foreign key → Untitled10.Key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
- Field8 — VARCHAR(255)
Untitled19
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
- Field10 — VARCHAR(255)
- Field2 — VARCHAR(255) — donation, goods
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255) — waiting, proceeding, finished, sold_out, deleted
- Field7 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field8 — VARCHAR(255)
- Field13 — VARCHAR(255)
Untitled2
- Key — uuid — Primary key — NOT NULL
- Field — uuid
- Field2 — varchar
- Field8 — varchar — kakao, google, facebook, apple, email
- Field3 — varchar
- Field10 — VARCHAR(255)
- Field11 — VARCHAR(255)
- Field13 — VARCHAR(255)
- Field14 — VARCHAR(255)
- Field7 — VARCHAR(255) — activated, inactivated, dormant
- Field4 — datetime
- Field5 — datetime
- Field6 — datetime
Untitled3
- Key2 — uuid — Foreign key → Untitled2.Key — NOT NULL
- Field10 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field12 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field8 — VARCHAR(255)
- Field9 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field7 — VARCHAR(255)
- Field11 — VARCHAR(255)
- Field — VARCHAR(255)
Untitled4
- Key — VARCHAR(255) — Primary key — NOT NULL
- Key2 — VARCHAR(255) — Foreign key → Untitled19.Key — NOT NULL
- Field4 — VARCHAR(255)
- Field2 — VARCHAR(255) — coupon, delivery, pickup
- Field — VARCHAR(255)
- Field5 — string — point type that can be used to buy this product
- Field13 — int — Points accumulated during the period can be used when purchasing goods
- Field8 — VARCHAR(255)
- Field9 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field12 — VARCHAR(255)
Untitled5
- Key — VARCHAR(255) — Primary key — NOT NULL
- Key2 — VARCHAR(255) — Foreign key → Untitled6.Key — NOT NULL
- Key3 — uuid — Foreign key → Untitled2.Key — NOT NULL
- Key4 — VARCHAR(255) — Foreign key → Untitled12.Key — NOT NULL
- Field — VARCHAR(255) — webin, webincam, event, cs
- Field2 — int
- Field3 — int
- Field5 — VARCHAR(255)
- Field7 — VARCHAR(255) — 2 years
- Field9 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field10 — VARCHAR(255)
Untitled6
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
- Field9 — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255) — all, region, selected
- Field5 — VARCHAR(255) — all, selected
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
- Field8 — VARCHAR(255)
Untitled7
- Key — VARCHAR(255) — Primary key — NOT NULL
- Key2 — VARCHAR(255) — Foreign key → Untitled12.Key — NOT NULL — console_user_uid
- Key3 — uuid — Foreign key → Untitled2.Key — NOT NULL
- Field — datetime
- Field2 — VARCHAR(255) — kakao, phone, email
- Field3 — VARCHAR(255) — point_not_credited, shopping, simple_inquiry, machine_broken, suggestions
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255) — receipted, processing, processed, unsolved, further_improvement
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
Untitled8
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255) — 피그마 6번에 오류 항목선택
- Field2 — VARCHAR(255) — 오분쇼핑, 배출함 장애, APP 장애 이런거
- Field3 — VARCHAR(255)
Untitled9
- Key — VARCHAR(255) — Primary key — NOT NULL
- Key2 — VARCHAR(255) — Foreign key → Untitled19.Key — NOT NULL
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field10 — VARCHAR(255)