리멤버
테이블 (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)