0813-project-erd
Tables (10)
User (user)
- User_code (user_code) — INT — Primary key — NOT NULL
- User_name (user_name) — VARCHAR
- User_email (user_email) — VARCHAR
- Oauth2_id (oauth2_id) — VARCHAR
- User_password (user_password) — VARCHAR
- User_address (user_address) — VARCHAR
- User_phone (user_phone) — VARCHAR
- User_gender (user_gender) — INT
- User_birth (user_birth) — VARCHAR
- User_profile_img (user_profile_img) — VARCHAR
- User_roles (user_roles) — VARCHAR
- User_provider (user_provider) — VARCHAR
- Create_date (create_date) — DATETIME
- Update_date (update_date) — DATETIME
board
- Board_code (board_code) — INT — Primary key — NOT NULL
- User_code (user_code2) — INT — Foreign key → User.User_code — NOT NULL
- Title (title) — VARCHAR
- Content (content) — VARCHAR
- User_code (user_code) — INT
- Create_date (create_code) — DATETIME
- Update_date (update_date) — DATETIME
contact
- Contact_code (contact_code) — INT — Primary key — NOT NULL
- Contact_category (contact_category) — VARCHAR
- Etc (etc) — VARCHAR
- Non_username (non_username) — VARCHAR
- Non_userphone (non_userphone) — VARCHAR
- Non_useremail (non_useremail) — VARCHAR
- Contact_content (contact_content) — TEXT
- Contact_agree (contact_agree) — VARCHAR
- Create_date (create_date) — DATETIME
- Update_date (update_date) — DATETIME
flag
- Flag_code (flag_code) — INT — Primary key — NOT NULL
- Flag_name (flag_name) — VARCHAR
heart
- Heart_code (heart_code) — INT — Primary key — NOT NULL
- User_code (user_code2) — INT — Foreign key → User.User_code — NOT NULL
- Program_code (program_code2) — INT — Foreign key → program.Program_code — NOT NULL
- User_code (user_code) — INT
- Program_code (program_code) — INT
- Create_date (create_date) — DATETIME
- Update_date (update_date) — DATETIME
notice
- Notice_code (notice_code) — INT — Primary key — NOT NULL
- User_code (user_code2) — INT — Foreign key → User.User_code — NOT NULL
- Notice_title (notice_title) — VARCHAR
- User_code (user_code) — INT
- Notice_content (notice_content) — TEXT
- Create_date (create_date) — DATETIME
- Update_date (update_date) — DATETIME
order_mst
- Order_code (order_code) — INT — Primary key — NOT NULL
- User_code (user_code2) — INT — Foreign key → User.User_code — NOT NULL
- Program_code (program_code2) — INT — Foreign key → program.Program_code — NOT NULL
- Flag_code (flag_code2) — INT — Foreign key → flag.Flag_code — NOT NULL
- User_code (user_code) — INT
- Program_code (program_code) — INT
- Flag_code (flag_code) — INT
- Create_date (create_date) — DATETIME
- Update_date (update_date) — DATETIME
program
- Program_code (program_code) — INT — Primary key — NOT NULL
- Program_theme (program_theme) — VARCHAR
- Program_title (program_title) — VARCHAR
- Program_price (program_price) — VARCHAR
- Program_info (program_info) — VARCHAR
- Program_place (program_place) — VARCHAR
- Program_schedule (program_schedule) — VARCHAR
- Program_time (program_time) — VARCHAR
- Program_participants (program_participants) — VARCHAR
- Program_option (program_option) — VARCHAR
- Program_heart (program_heart) — INT
- Program_imgUrl_1 (program_imgUrl_1) — VARCHAR
- Program_imgUrl_2 (program_imgUrl_2) — VARCHAR
- Create_date (create_date) — DATETIME
- Update_date (update_date) — DATETIME
purchase_review
- Purchase_review_code (purchase_review_code) — INT — Primary key — NOT NULL
- User_code (user_code2) — INT — Foreign key → User.User_code — NOT NULL
- Pr_profile_img1 (pr_profile_img1) — VARCHAR
- Pr_profile_img2 (pr_profile_img2) — VARCHAR
- Pr_profile_img3 (pr_profile_img3) — VARCHAR
- Pr_profile_img4 (pr_profile_img4) — VARCHAR
- Pr_profile_img5 (pr_profile_img5) — VARCHAR
- Pr_profile_img6 (pr_profile_img6) — VARCHAR
- User_code (user_code) — VARCHAR
- Star_rate (star_rate) — VARCHAR
- Content_code (content_code) — INT
- Create_date (create_date) — DATETIME
- Update_date (update_date) — DATETIME
state
- State_code (state_code) — INT — Primary key — NOT NULL
- Flag_code (flag_code) — INT — Foreign key → flag.Flag_code — NOT NULL
- State_code_name (state_code_name) — VARCHAR
- State_code_num (state_code_num) — INT