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