Odya

Tables (14)

community (CopyOfCopyOf회원2)

  • id (PK) — NOT NULL — Primary key — NOT NULL
  • content (Field4) — NOT NULL
  • visibility (Field11) — NOT NULL
  • place_id (Field) — NULL
  • like_count (Field2) — NOT NULL
  • created_date (Field3) — NOT NULL
  • updated_date (Field5) — NOT NULL
  • user_id (PK2) — NOT NULL — Foreign key → users.id — NOT NULL
  • topic_id (Key) — NULL — Foreign key → topic.id — NOT NULL
  • travel_journal_id (PK3) — NULL — Foreign key → travel_journal.id — NOT NULL

community_comment (CopyOfCopyOfCopyOf회원2)

  • id (PK) — NOT NULL — Primary key — NOT NULL
  • content (Field4) — NOT NULL
  • created_date (Field3) — NOT NULL
  • updated_date (Field5) — NOT NULL
  • user_id (PK2) — NOT NULL — Foreign key → users.id — NOT NULL
  • community_id (PK3) — NOT NULL — Foreign key → community.id — NOT NULL

community_content_image (CopyOfCopyOfUntitled)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • created_date (Field) — NOT NULL
  • content_image_id (Key2) — NOT NULL — Foreign key → content_image.id — NOT NULL
  • community_id (PK) — NOT NULL — Foreign key → community.id — NOT NULL

community_like (CopyOf팔로우)

  • community_id (PK) — NOT NULL — Primary key — NOT NULL
  • user_id (PK2) — NOT NULL — Foreign key → users.id — NOT NULL
  • created_date (Field3) — NOT NULL

content_image (CopyOfUntitled2)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • name (Field3) — NOT NULL
  • origin_name (Field) — NOT NULL
  • created_date (Field4) — NOT NULL
  • is_life_shot (Field2) — NOT NULL
  • user_id (PK) — NOT NULL — Foreign key → users.id — NOT NULL

follow (팔로우)

  • follower_id (PK) — NOT NULL — Foreign key → users.id — NOT NULL
  • following_id (PK2) — NOT NULL — Foreign key → users.id — NOT NULL
  • created_date (Field3) — NOT NULL

life_shot (CopyOfCopyOfUntitled2)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • created_date (Field4) — NOT NULL

topic (CopyOfUntitled3)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • word (Field) — NOT NULL

travel_companion (Untitled)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • username (Field) — NULL
  • created_date (Field3) — NOT NULL
  • travel_journal_id (PK) — NOT NULL — Foreign key → travel_journal.id — NOT NULL
  • user_id (PK2) — NULL — Foreign key → users.id — NOT NULL

travel_journal (CopyOf회원)

  • id (PK) — NOT NULL — Primary key — NOT NULL
  • title (Field4) — NOT NULL
  • travel_start_date (Field10) — NOT NULL
  • travel_end_date (Field2) — NOT NULL
  • visibility (Field11) — NOT NULL
  • created_date (Field3) — NOT NULL
  • updated_date (Field5) — NOT NULL
  • user_id (PK2) — NOT NULL — Foreign key → users.id — NOT NULL

travel_journal_bookmark (CopyOfUntitled4)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • created_date (Field3) — NOT NULL
  • travel_journal_id (PK) — NOT NULL — Foreign key → travel_journal.id — NOT NULL
  • user_id (PK2) — NOT NULL — Foreign key → users.id — NOT NULL

travel_journal_content (CopyOfCopyOf회원)

  • id (PK) — NOT NULL — Primary key — NOT NULL
  • content (Field4) — NOT NULL
  • place_id (Field10) — NOT NULL
  • coordinates (Field2) — NOT NULL
  • travel_date (Field) — NOT NULL
  • created_date (Field3) — NOT NULL
  • updated_date (Field5) — NOT NULL
  • travel_journal_id (PK2) — NOT NULL — Foreign key → travel_journal.id — NOT NULL

travel_journal_content_image (CopyOfUntitled)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • created_date (Field) — NOT NULL
  • travel_journal_content_id (PK) — NOT NULL — Foreign key → travel_journal_content.id — NOT NULL
  • content_image_id (Key2) — NOT NULL — Foreign key → content_image.id — NOT NULL

users (회원)

  • id (PK) — NOT NULL — Primary key — NOT NULL
  • username (Field4) — NOT NULL
  • email (Field10) — NOT NULL
  • nickname (Field2) — NOT NULL
  • phone_number (Field11) — NULL
  • gender (Field) — NOT NULL
  • birthday (Field3) — NOT NULL
  • profile_name (Field5) — NOT NULL
  • user_role (Field7) — NOT NULL
  • social_type (Field6) — NOT NULL
  • withdraw_date (Field8) — NULL
  • created_date (Field9) — NOT NULL