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