캡스톤디자인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