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