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