SeaTea

Tables (8)

Login_history (로그인 기록)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
  • login_at (Field) — DATETIME
  • ip_address (Field2) — VARCHAR
  • user_agent (Field3) — VARCHAR

Place (공간)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR
  • address (Field2) — VARCHAR
  • lng (Field3) — DOUBLE
  • lat (Field4) — DOUBLE
  • opening_hours (Field5) — DATETIME
  • description (Field6) — VARCHAR
  • created_at (Field7) — DATETIME
  • updated_at (Field8) — DATETIME

User (유저)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • email (Field) — VARCHAR
  • passwd (Field2) — VARCHAR
  • nickname (Field3) — VARCHAR
  • profile_image (Field4)
  • created_at (Field5) — DATETIME
  • updated_at (Field6) — DATETIME
  • type_id (Key2) — BIGINT — Foreign key → type.id — NOT NULL

User_Auth (소셜 로그인)

  • id (Key2) — BIGINT — Primary key — NOT NULL
  • id (Key) — BIGINT — Foreign key → User.id — NOT NULL
  • provider (Field) — ENUM
  • provider_id (Field2) — VARCHAR

User_place (사용자 공간)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
  • place_id (Key3) — BIGINT — Foreign key → Place.id — NOT NULL
  • created_at (Field) — DATETIME

diagnosis (진단)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • method (Field) — ENUM
  • created_at (Field2) — DATETIME
  • Field3
  • user_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
  • type_id (Key3) — BIGINT — Foreign key → type.id — NOT NULL

recommend_place (추천 공간)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • place_id (Key2) — BIGINT — Foreign key → Place.id — NOT NULL
  • reason (Field) — VARCHAR
  • type_id (Key3) — BIGINT — Foreign key → type.id — NOT NULL

type (휴식 유형)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — ENUM