michiki

Tables (5)

DailyPlan (Untitled2)

    Member (user info)

    • user_id — int — Primary key — NOT NULL
    • social_id (Field8) — varchar(128)
    • social_type (Field) — enum
    • email (Field2) — varchar(255) — NOT NULL
    • nickname (Field3) — varchar(64) — NOT NULL
    • created_at (Field4) — timestamp

    Place (Untitled)

    • place_id (Key) — uuid — Primary key — NOT NULL
    • user_id (added by) — int — Foreign key → Member.user_id — NOT NULL
    • longitude (경도) — long
    • latitude (위도) — long
    • type (타입) — enum
    • memo (Field3) — clob

    Plan (Untitled3)

      Room (Untitled4)

      • room_id (Key) — Primary key — NOT NULL
      • Field
      • Field2
      • Field3