MaeilMeil

Tables (4)

Favor (CopyOfUntitled)

  • favor_id (아이디) — Primary key — NOT NULL
  • user_id (유저아아디) — Foreign key → Member.user_id — NOT NULL
  • movie (영화)
  • language (언어)
  • book (독서)
  • game (게임)
  • coding (코딩)
  • fantasy (판타지)
  • sports (스포츠)
  • entertainment (엔터테이너)
  • music (음악)
  • fashion (패션)
  • art (예술)
  • travel (Field12)

Language (Untitled3)

  • language_id (Key) — Primary key — NOT NULL
  • user_id (유저아이디) — Foreign key → Member.user_id — NOT NULL
  • afrikaans (Field)
  • chiniese (Field2)
  • english (Field3)
  • french (Field4)
  • german (Field5)
  • japanese (Field6)
  • korean (Field7)
  • russian (Field8)
  • spanish (Field9)
  • Field10

Letter (Untitled2)

  • letter_id (아이디) — Primary key — NOT NULL
  • user_id (유저아이디) — Foreign key → Member.user_id — NOT NULL
  • send_id (보낸아이디)
  • receive_id (받는아이디)
  • send_location (보낸위치)
  • receive_location (받는위치)
  • send_date (보낸시간)
  • receive_date (받은시간)
  • content (내용)
  • is_arrived (도착했는지여부)
  • is_read (읽었는지여부)
  • delivery_time (배송시간)

Member (Untitled)

  • user_id (아이디) — Primary key — NOT NULL
  • nickname (닉네임)
  • email (이메일)
  • password (비밀번호)
  • gender (성별)
  • birthday (생일)
  • location (현재위치)
  • latitude (위도)
  • longitude (경도)
  • status (상태)
  • profile_text (프로필설명)
  • profile_image (프로필이미지)
  • created_at (생성시간)
  • updated_at (업데이트 시간)