Mitchinmat

Tables (9)

Untitled

    comment (댓글)

    • id — BIGINT — Primary key — NOT NULL
    • user_id — BIGINT — Foreign key → user.id — NOT NULL
    • place_id — BIGINT — Foreign key → place.id — NOT NULL
    • content — VARCHAR(255)

    friend (친구)

    • id — BIGINT — Primary key — NOT NULL
    • user_id — BIGINT — Foreign key → user.id — NOT NULL
    • friend_id — BIGINT — NOT NULL

    friend_of_friend (모든 친구)

    • user_id — BIGINT — Foreign key → user.id — NOT NULL
    • friend_id_list — VARCHAR(255)

    good_place (맛집)

    • user_id — BIGINT — Foreign key → user.id — NOT NULL
    • place_id — BIGINT — Foreign key → place.id — NOT NULL
    • memo — TEXT
    • custom_tag — VARCHAR(255)

    place (음식점)

    • id (place_id) — BIGINT — Primary key — NOT NULL
    • place_name — VARCHAR(255)
    • address_name — VARCHAR(255)
    • road_address_name — VARCHAR(255)
    • phone_number — VARCHAR(20)
    • place_image_url — VARCHAR(255)
    • x — DOUBLE
    • y — DOUBLE

    place_URL (음식점 url)

    • place_id — BIGINT — Foreign key → place.id — NOT NULL
    • place_url — VARCHAR(255)
    • search_url — VARCHAR(255)
    • load_find_url — VARCHAR(255)

    place_category (음식점 카테고리)

    • place_id — BIGINT — Foreign key → place.id — NOT NULL
    • level — INT
    • name — VARCHAR(10)

    user (사용자)

    • id (user_id) — BIGINT — Primary key — NOT NULL
    • oauth2_id — VARCHAR(255)
    • role — ENUM
    • provider — ENUM
    • username — VARCHAR(10)
    • profile_image — VARCHAR(255)
    • good_place_count — BIGINT
    • inactive_date — DATE
    • status (staus) — ENUM