JNHS

Tables (15)

Acquisition

  • acquisition_id — Primary key — NOT NULL
  • acquisition_name
  • acquisition_detail
  • acquisition_found_date
  • acquisition_image
  • acquisition_state
  • acquisition_enter_date
  • laf_id — Foreign key → LostAndFound.laf_id — NOT NULL
  • found_place_id (place_id) — Foreign key → Place.place_id — NOT NULL
  • minor_category_id — Foreign key → MinorCategory.minor_category_id — NOT NULL
  • user_email — Foreign key → NormalUser.user_email — NOT NULL

Admin

  • admin_id — Primary key — NOT NULL
  • admin_pw

Agreement

  • agreement_id — Primary key — NOT NULL
  • agreement_name
  • agreement_detail

Class

  • class_id — Primary key — NOT NULL
  • grade
  • class (classd)
  • department_id — Foreign key → Department.department_id — NOT NULL

Department

  • department_id — Primary key — NOT NULL
  • department_name

LostAndFound

  • laf_id — Primary key — NOT NULL
  • laf_name
  • place_id — Foreign key → Place.place_id — NOT NULL

LostItem

  • lost_item_id — Primary key — NOT NULL
  • lost_item_name
  • lost_item_detail
  • lost_item_lost_date
  • lost_item_image
  • lost_item_state
  • lost_item_enter_date
  • place_id — Foreign key → Place.place_id — NOT NULL
  • minor_category_id — Foreign key → MinorCategory.minor_category_id — NOT NULL
  • user_email — Foreign key → NormalUser.user_email — NOT NULL

MajorCategory

  • major_category_id — Primary key — NOT NULL
  • major_category_name

MediumCategory

  • medium_category_id — Primary key — NOT NULL
  • medium_category_name
  • major_category_id — Foreign key → MajorCategory.major_category_id — NOT NULL

MinorCategory

  • minor_category_id — Primary key — NOT NULL
  • minor_category_name
  • medium_category_id — Foreign key → MediumCategory.medium_category_id — NOT NULL

NormalUser

  • user_email — Primary key — NOT NULL
  • first_name
  • last_name
  • phone
  • date
  • user_type

Place

  • place_id — Primary key — NOT NULL
  • place_name
  • place_coordinate

Student

  • user_email — Foreign key → NormalUser.user_email — NOT NULL
  • password
  • std_num
  • account_state
  • class_id — Foreign key → Class.class_id — NOT NULL

Teacher

  • user_email — Foreign key → NormalUser.user_email — NOT NULL
  • password
  • class_id — Foreign key → Class.class_id — NOT NULL

User_Agreement

  • agreement_id — Foreign key → Agreement.agreement_id — NOT NULL
  • user_email — Foreign key → NormalUser.user_email — NOT NULL
  • check
  • date