리멤버

테이블 (10)

Address (Untitled3)

  • address_id (Key) — 기본 키 — NOT NULL
  • company_id (Key2) — 외래 키 → Company.company_id — NOT NULL
  • zip_code (Field)
  • road_addr (Field2)
  • base_addr (Field3)
  • detail_addr (Field4)

BusinessCard (CopyOfUntitled)

  • card_id (Key) — 기본 키 — NOT NULL
  • user_id (Key2) — 외래 키 → User.user_id — NOT NULL
  • company_id (Key22) — 외래 키 → Company.company_id — NOT NULL
  • address_id (Key3) — 외래 키 → Address.address_id — NOT NULL
  • company_id (Key23) — 외래 키 → Address.company_id — NOT NULL
  • department (Field)
  • position (Field2)
  • job (Field3)
  • tel_no (Field4)
  • fax_no (Field6)

Comment (CopyOfUntitled4)

  • comment_id (Key) — 기본 키 — NOT NULL
  • posting_id (Key2) — 외래 키 → Content.content_id — NOT NULL
  • user_id (Key3) — 외래 키 → Content.user_id — NOT NULL
  • comment_content (Field)

Company (Untitled2)

  • company_id (Key2) — 기본 키 — NOT NULL
  • company_name (Field)
  • representative_name (Field2)
  • sector_type (Field3)
  • company_type (Field4)

Content (CopyOfUntitled22)

  • content_id (Key2) — 기본 키 — NOT NULL
  • user_id (Key) — 외래 키 → User.user_id — NOT NULL
  • content (Field)
  • image_url (Field2)
  • likes (Field3)
  • content_url (Field4)
  • input_dttm (Field5)

Disease (Untitled6)

  • disease_code (Key) — 기본 키 — NOT NULL
  • disease_name (Field)
  • symptom (Field2)
  • patient_id (Key3) — 외래 키 → Patient.patient_id — NOT NULL

Friend (CopyOfUntitled2)

  • user_id (Key) — 기본 키 — NOT NULL
  • user_id (Key2) — 외래 키 → User.user_id — NOT NULL
  • apply_dttm (Field)
  • end_dttm (Field2)
  • status (Field3)

Patient (Untitled5)

  • patient_id (Key) — 기본 키 — NOT NULL
  • patient_name (Field)
  • disease_code (Field2)
  • age (Field3) — NOT NULL

Posting (Untitled4)

  • posting_id (Key) — 기본 키 — NOT NULL
  • company_id (Key2) — 외래 키 → Company.company_id — NOT NULL
  • title (Field)
  • start_dttm (Field2)
  • end_dttm (Field3)
  • address_id (Field4)
  • posting_content (Field5)
  • image_url (Field6)

User (Untitled)

  • user_id (Key) — 기본 키 — NOT NULL
  • username (Field)
  • password (Field2)
  • birth_dttm (Field3)
  • phone_no (Field4)
  • email (Field5)