캡스톤디자인1

테이블 (5)

FAMILY_POST (Untitled3)

  • fp_id (Key2) — str — 기본 키 — NOT NULL
  • user_id (Key) — str — 외래 키 → USER.user_id — NOT NULL
  • face_img_aging (Field) — img
  • face_img_origin (Field2) — img
  • photo_age (Field3) — int
  • missing_brith (Field4) — date — NOT NULL
  • missing_date (Field6) — date
  • missing_name (Field7) — str — NOT NULL
  • missing_situation (Field8) — str
  • missing_extra_evidence (Field9) — str
  • missing_place (Field10) — str — NOT NULL
  • gender_id (Key3) — int — 외래 키 → gender.gender_id — NOT NULL
  • permission (Field5) — boolean

MISSING_POST (Untitled4)

  • mp_id (Key2) — str — 기본 키 — NOT NULL
  • user_id (Key) — str — 외래 키 → USER.user_id — NOT NULL
  • face_img_origin (Field) — img
  • missing_date (Field2) — date
  • missing_name (Field4) — str — NOT NULL
  • missing_situation (Field5) — str
  • missing_birth (Field6) — date
  • missing_place (Field7) — str
  • missing_extra_evidence (Field8) — str
  • gender_id (Key3) — int — 외래 키 → gender.gender_id — NOT NULL
  • permission (Field3) — boolean

USER (Untitled2)

  • user_id (Key) — str — 기본 키 — NOT NULL
  • user_nm (Field) — str — NOT NULL
  • user_pw (Field2) — str — NOT NULL
  • user_email (Field3) — str — NOT NULL
  • birthday (Field4) — date — NOT NULL
  • user_type (Key2) — int — 외래 키 → USER_TYPE.user_type — NOT NULL

USER_TYPE (Untitled5)

  • user_type (Key) — int — 기본 키 — NOT NULL
  • type_name (Field) — str

gender (Untitled)

  • gender_id (Key) — int — 기본 키 — NOT NULL
  • gender_name (Field) — str — NOT NULL